Count number of occurences by day of week??

[losingmymind]

Hi there. I am trying to figure out how to count events by day of week. I have created a basic query that will convert my Date_of_Event into a week day but what I cant figure out is how to count occurences for any given day. For example, on a report I want to have everyday of the week listed and a total number of events that occurred on each day. Can anyone please help?

[June7]

Do you care about week, month, year? At what level do you want the data to aggregate? Do you want a total for all Mondays, etc. regardless of week, month, year?

If a date does not have any events then it won't list on report.

Build a report and use Grouping & Sorting features with aggregate calcs in header/footer.

[losingmymind]

I want to put in a date range and have it total the number of events that occurred on each day. I don't want to see each date, just "Sunday - 3" "Monday - 10" "Tuesday - 5" etc....the date range could be a whole year or just 2 weeks. I don't know what an aggregate calc is, sorry.

[June7]

An aggregate calc would be a sum or count or average of records. Like:

SELECT Weekday([datefield]) AS WkDy, Count("*") FROM tablename GROUP BY Weekday([datefield]) WHERE [datefield] BETWEEN [enter start] AND [enter end];

A GROUP BY (aggregate) query can be created in query design view by clicking the Totals button from the ribbon. Access Help has guidelines on using the query designer and building aggregate queries.