Totals Count Query ?

[on-2]

I have just got my head around a aggregate query to count the number of results of a certain date using the search here on the forum but . .

I was trying to count all dates by the day of the week?

There are over 1000 dates but i was hoping for a query with 7 results showing how many on each day i.e. mon 300, tues 250 etc etc.

Is this possible?

 

[Oksana]

totals query

Use totals query:

First column:

WeekDay: Format([OrderDate],"w")
Group By

Second Column:

HowMany: [WeekDay]
Count