I have a table that has Event, Start day and End day as some of the fields. I would like to have a query that totals the number events for each day of the week. The tricky part is that the start day and end day may be different and I need to count the totals on both days.
Example:
Sample Data in table:
Event/Start Day/End Day
1/Mon/Mon
2/Mon/Tues
3/Mon/Wed
4/Wed/Fri
5/Sun/Thu
I would like the query to produce the following:
Day/No. Events
Sun/1
Mon/4
Tue/3
Wed/3
Thu/2
Fri/1
Sat/0
Any help you can provide would be greatly appreciated.