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
|
|||
|
|||
totals in query
I have 4 different queries based on one column of the same table.
What I need is to create a report that will give me the total amounts of my 4 queries, and that can compare it to a grand total (translated in %of) How do I do this? If I try to base my report on a querie that pulls all information, the "grouping" feature does not let me combine the sections I need per group. f.a. my table column is based on order codes: AMA, DDA, PROM, STD, GSA, SGO my first query only pulls orders in the combination PROM & STD my second query only pulls orders for GSA & SGO The 3 fields I need to compare totals of a list price, net price, order code with the result of GSA/SGO total list price $ which is xx% of the Total sales list Please help, I'm totally clueless |
#2
|
|||
|
|||
Do you have a code table that has a field for the code and a field for the
"grouping"? If not, consider creating one so that you don't need 4 different queries. Combining your records into a single query that is grouped by your code "grouping" field should provide your totals. -- Duane Hookom MS Access MVP "Monique" wrote in message ... I have 4 different queries based on one column of the same table. What I need is to create a report that will give me the total amounts of my 4 queries, and that can compare it to a grand total (translated in %of) How do I do this? If I try to base my report on a querie that pulls all information, the "grouping" feature does not let me combine the sections I need per group. f.a. my table column is based on order codes: AMA, DDA, PROM, STD, GSA, SGO my first query only pulls orders in the combination PROM & STD my second query only pulls orders for GSA & SGO The 3 fields I need to compare totals of a list price, net price, order code with the result of GSA/SGO total list price $ which is xx% of the Total sales list Please help, I'm totally clueless |
#3
|
|||
|
|||
It would be great to have 1 query instead, but how do I do this? Also will it
be able to give me the grand totals for List and Net per group? "Duane Hookom" wrote: Do you have a code table that has a field for the code and a field for the "grouping"? If not, consider creating one so that you don't need 4 different queries. Combining your records into a single query that is grouped by your code "grouping" field should provide your totals. -- Duane Hookom MS Access MVP "Monique" wrote in message ... I have 4 different queries based on one column of the same table. What I need is to create a report that will give me the total amounts of my 4 queries, and that can compare it to a grand total (translated in %of) How do I do this? If I try to base my report on a querie that pulls all information, the "grouping" feature does not let me combine the sections I need per group. f.a. my table column is based on order codes: AMA, DDA, PROM, STD, GSA, SGO my first query only pulls orders in the combination PROM & STD my second query only pulls orders for GSA & SGO The 3 fields I need to compare totals of a list price, net price, order code with the result of GSA/SGO total list price $ which is xx% of the Total sales list Please help, I'm totally clueless |
#4
|
|||
|
|||
The table I am using is a link to our National sales. My querie is only for 1
part number in a particular time frame, f.a. partnumber 12345 for the period of 1 year, separated into the groups below. That is why I had created 4 different queries. If I am able to do this based on 1 query and still get my groups, that would be great. I am however unable to "touch" the original table it pulls from. Also, I am trying to set up a "master" query for these reports I need, so I would need to be able to redefine my part number and time frames. Right now, I have set these as my parameters. "Duane Hookom" wrote: Do you have a code table that has a field for the code and a field for the "grouping"? If not, consider creating one so that you don't need 4 different queries. Combining your records into a single query that is grouped by your code "grouping" field should provide your totals. -- Duane Hookom MS Access MVP "Monique" wrote in message ... I have 4 different queries based on one column of the same table. What I need is to create a report that will give me the total amounts of my 4 queries, and that can compare it to a grand total (translated in %of) How do I do this? If I try to base my report on a querie that pulls all information, the "grouping" feature does not let me combine the sections I need per group. f.a. my table column is based on order codes: AMA, DDA, PROM, STD, GSA, SGO my first query only pulls orders in the combination PROM & STD my second query only pulls orders for GSA & SGO The 3 fields I need to compare totals of a list price, net price, order code with the result of GSA/SGO total list price $ which is xx% of the Total sales list Please help, I'm totally clueless |
#5
|
|||
|
|||
Do you have some table and field names you would like to share? I still
don't know if you have a value stored in a field that describes your grouping of codes. -- Duane Hookom MS Access MVP "Monique" wrote in message ... It would be great to have 1 query instead, but how do I do this? Also will it be able to give me the grand totals for List and Net per group? "Duane Hookom" wrote: Do you have a code table that has a field for the code and a field for the "grouping"? If not, consider creating one so that you don't need 4 different queries. Combining your records into a single query that is grouped by your code "grouping" field should provide your totals. -- Duane Hookom MS Access MVP "Monique" wrote in message ... I have 4 different queries based on one column of the same table. What I need is to create a report that will give me the total amounts of my 4 queries, and that can compare it to a grand total (translated in %of) How do I do this? If I try to base my report on a querie that pulls all information, the "grouping" feature does not let me combine the sections I need per group. f.a. my table column is based on order codes: AMA, DDA, PROM, STD, GSA, SGO my first query only pulls orders in the combination PROM & STD my second query only pulls orders for GSA & SGO The 3 fields I need to compare totals of a list price, net price, order code with the result of GSA/SGO total list price $ which is xx% of the Total sales list Please help, I'm totally clueless |
#6
|
|||
|
|||
my table name is: core_vs_ship
the field names that I am using in my query: BUS_YR_MO; PART_NO; CUST_NAME; PCC; ORDER_NO; LIST_PRICE; NET_PRICE The PCC field is the field that holds the clue for my grouping, it holds data like PROM1299 or AMAW1245 I have a parameter for the part no, a time frame and I will need to pull data that belong to any of my groups, as well as a total for the list and net amount per group to be compared with a grand total of these groups. "Duane Hookom" wrote: Do you have some table and field names you would like to share? I still don't know if you have a value stored in a field that describes your grouping of codes. -- Duane Hookom MS Access MVP "Monique" wrote in message ... It would be great to have 1 query instead, but how do I do this? Also will it be able to give me the grand totals for List and Net per group? "Duane Hookom" wrote: Do you have a code table that has a field for the code and a field for the "grouping"? If not, consider creating one so that you don't need 4 different queries. Combining your records into a single query that is grouped by your code "grouping" field should provide your totals. -- Duane Hookom MS Access MVP "Monique" wrote in message ... I have 4 different queries based on one column of the same table. What I need is to create a report that will give me the total amounts of my 4 queries, and that can compare it to a grand total (translated in %of) How do I do this? If I try to base my report on a querie that pulls all information, the "grouping" feature does not let me combine the sections I need per group. f.a. my table column is based on order codes: AMA, DDA, PROM, STD, GSA, SGO my first query only pulls orders in the combination PROM & STD my second query only pulls orders for GSA & SGO The 3 fields I need to compare totals of a list price, net price, order code with the result of GSA/SGO total list price $ which is xx% of the Total sales list Please help, I'm totally clueless |
#7
|
|||
|
|||
I'm still lost. Can you share some sample records and desired display?
-- Duane Hookom MS Access MVP "Monique" wrote in message ... my table name is: core_vs_ship the field names that I am using in my query: BUS_YR_MO; PART_NO; CUST_NAME; PCC; ORDER_NO; LIST_PRICE; NET_PRICE The PCC field is the field that holds the clue for my grouping, it holds data like PROM1299 or AMAW1245 I have a parameter for the part no, a time frame and I will need to pull data that belong to any of my groups, as well as a total for the list and net amount per group to be compared with a grand total of these groups. "Duane Hookom" wrote: Do you have some table and field names you would like to share? I still don't know if you have a value stored in a field that describes your grouping of codes. -- Duane Hookom MS Access MVP "Monique" wrote in message ... It would be great to have 1 query instead, but how do I do this? Also will it be able to give me the grand totals for List and Net per group? "Duane Hookom" wrote: Do you have a code table that has a field for the code and a field for the "grouping"? If not, consider creating one so that you don't need 4 different queries. Combining your records into a single query that is grouped by your code "grouping" field should provide your totals. -- Duane Hookom MS Access MVP "Monique" wrote in message ... I have 4 different queries based on one column of the same table. What I need is to create a report that will give me the total amounts of my 4 queries, and that can compare it to a grand total (translated in %of) How do I do this? If I try to base my report on a querie that pulls all information, the "grouping" feature does not let me combine the sections I need per group. f.a. my table column is based on order codes: AMA, DDA, PROM, STD, GSA, SGO my first query only pulls orders in the combination PROM & STD my second query only pulls orders for GSA & SGO The 3 fields I need to compare totals of a list price, net price, order code with the result of GSA/SGO total list price $ which is xx% of the Total sales list Please help, I'm totally clueless |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
count number of records | Joe_Access | General Discussion | 1 | January 13th, 2005 06:27 PM |
Totals query with an expression | LMB | New Users | 6 | November 24th, 2004 03:59 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Query to join records form 2 databases | bdehning | General Discussion | 5 | August 9th, 2004 03:09 PM |