Simple, right?

[andysgirl8800]

This should be a very simple report, and yet I cannot figure it out and I need a solution within a few hours! I have records, sorted by date. I've managed to group them by month, but not summarize by month. Each record has a status, (such as denied, approved, retracted, etc). What I want to do is have the report say "July" without showing me all the entries for July, and then the total # of denied, approved, retracted, etc. then, in the same report, in a new section, I want the same for August. Make sense? I've never built a report before, so I don't know where to start, and I'm beginning to get very frustrated. Please help! Right now, it looks like this (and I cannot get it to calculate):
July
7/1/05 Denied
7/1/05 Approved
7/1/05 Approved
7/2/05 Denied
August
8/1/05 Approved
8/2/05 Denied
....etc.
A simple explanation must be available, right? let me know if I've not explained it clearly enough. Thank you in advance!

 

[iago18]

Without looking at the data, here is my assessment...

In the recordsource for the report, modify the query to include a 'Group By' on both the Month and Status fields (i.e. Denied). Then also have the query contain a field which Counts the number of records for each grouping.

In the query interface, you need to add the 'Totals' property in order to access these Group By abilities. This Total property is where you tell Access if it should GroupBy or Count the values for a particular field.

Sorry I'm not being more descriptive...hopefully this helps you step in the right direction.