Sum

  • Thread starter Thread starter LG
  • Start date Start date
L

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!
 
LG,

The easiest way to do this is use the Report Wizard and sest the query as
your RecordSource. During the course of the Wizard you will get the
opportunity to Group in QCP_ID and create totals. Once done, if you have
some tweaking come back if you can't figure it out.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Back
Top