If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum
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! |
#2
|
|||
|
|||
Sum
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 "LG" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|