query to calculate busiest day

michellerobinso

Registered User.
Local time
Today, 20:50
Joined
Jun 14, 2006
Messages
47
i would like to run a query that works out the busiest day in a month but i also want to run a range from two dates and be able to convert them to

mon ? entries
tue ? entries

and so on

is this possible?

many thanks

michelle
 
Use a count query to show the busiest day, sort descending, then you have the largest figure first.

Check out the Format() in access help to convert a date to the day name.

Col
 

Users who are viewing this thread

Back
Top Bottom