C
Chip
I am having a heck of a time getting a SubTotal in my
query... I have a table of Inventory that can have many
identical products from different vendors but i want to
only show the total quantity of the product (the subtotal
of that product from any vendor. I.E. :
Product ABC from
ACME total of 26
XYZ co. total of 34
total of product ABC 60.
I only want my final report to show the total of 60 not
the individual vendor quantities because i will put a
filter on it to only show the Products that their totals
are below '75' so we know what needs re-ordering.
I can get the report to sum the products but not to filter
out the items above a total quantity of 75. So i am
thinking i need to Sub-total the products in the query and
filter them by the quantity of 75 there in the query.
Any help would be appreciated!!!! Thanks in advance!!!
query... I have a table of Inventory that can have many
identical products from different vendors but i want to
only show the total quantity of the product (the subtotal
of that product from any vendor. I.E. :
Product ABC from
ACME total of 26
XYZ co. total of 34
total of product ABC 60.
I only want my final report to show the total of 60 not
the individual vendor quantities because i will put a
filter on it to only show the Products that their totals
are below '75' so we know what needs re-ordering.
I can get the report to sum the products but not to filter
out the items above a total quantity of 75. So i am
thinking i need to Sub-total the products in the query and
filter them by the quantity of 75 there in the query.
Any help would be appreciated!!!! Thanks in advance!!!