Query

[Buffy]

For my booking system I need to find out which time of appointment is the most popular (For example, how often the time 9.00 occurs in my table). Any ideas how I could find this?

Thanx!

 

[John in PA]

Try this. First create a new query with the time field selected twice. Click the AutoSum button and group the second entry by count and sort descending. This query will give you the appointment time and the number of appointments made at that time.

 

[Corticus]

Nice solution John,

I've been looking for a better way to do counts, myself.

Thanks,

 

[Buffy]

Cool, Thank You!