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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top