Query-Report

[LG]

I have a table that has the following fields that I used in a query:
Date
QCP_ID
Batch_ID
Platform
The query is set to enter a date or range of dates. The platform field
consists of 4 different platforms. I need a report to show all the platforms
for each QCP_ID and than a grand total.
Ex.
DATE QCP_ID BATCH1 (this is set up to count) Platform
7/28/2009 DAN2 DS07282009C-1 15 RX
7/28/2009 DAN2 DS07282009P-2 250 Pharm
7/28/2009 DAN2 DS07282009Q-2 50 QL
7/28/2009 CS1 CS07282009C-1 25 RX
7/28/2009 CS1 CS07282009Q-1 50 QL
7/28/2009 NJ50 NJ07282009C-1 25 RX
7/28/2009 NJ50 NJ07282009P-1 50
Pharm

Now that I have the query I need to build the report to total everything for
each agent (QCP_ID) and than a combined total of everyone. I still need each
batch to show seperately as it does above.
Any help is appreciated!

 

[Dale Fye]

You only listed 4 fields in your field list, but included 5.

I would add a group to the Report. Set it to group on the QCP_ID field.
Then modify the settings of the group to include a footer. Copy the field
from the detail section for the count, and place it in the group footer.
Then change it's control Source property to:

= Sum([CountFieldName])

You will probably want to change the caption to "Total:" or something like
that.
Then, do the same thing and put the new copy in the reports footer.

This will give you a total for each QCP_ID, and an overall total for the
report.