Subtotals in Queries

[chris990]

Hi,

I'm trying to produce a subtotal in a query to compare it to another field to determine whether to include the record or not.

For example, in my table I'd have,

ProductA 3(units) Lot1
ProductA 4(units) Lot2
ProductB 2(units) Lot3

ProductA would also have a minimum inventory level of 6 in another table. So the parameter I would like to create would sum all the different lots of ProductA and compare it to the MinLevel entry.

Any ideas?

 

[chris990]

Hi guys,

Just want to give people one more look at this. I am still stuck with this!

I need to somehow group similar products, and add their quantities to compare to another value.

Can this be specified in the criteria section?

Thanks

 

[pbaldy]

Actually it is possible to get a query with subtotals, though I would generally just do it in a report too. A.D. Tejpal demonstrates a method in this sample:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='QueryWithSubTotals.mdb'