totals in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 are: 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
 
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.
 
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?
 
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.
 
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.
 
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.
 
Back
Top