Time groups within Date groups in Access

C

cyberchoc

I have a report in which I group event occurences (grouped by time) within
dates grouped and sorted by date. I'd like the format of the report to look
like the following using Access2003:
monday, 7/6/2009
9AM event 1 data
10AM event 2 data
count for monday= 2
Thursday, 7/9/2009
3PM event 3 data
6PM event 4 data
count for thursday = 2

Total count for report = 4
I tried every thing I could think of and the best I get is a count of 1 for
the daily and a count of 2 for the report . Can anyone help? I've spent an
entire day on it.
 
B

Beth Melton

Have you tried using a PivotTable? Based on what you describe it sounds
like this is what you need. Otherwise you may want to post in one of the
Access specific newsgroups since that's where the Access gurus tend to hang
out.

Here's a link to a tutorial on PivotTables that you may find useful:
http://office.microsoft.com/en-us/access/HA010345801033.aspx

~Beth Melton
Microsoft Office MVP
 
Top