Query of a Query Question

[krisN]

Hello, I have a query with the fields "Product Type", "Quantity", and "Cost". I want to create another Query of this query that sums the quantity and cost in separate fields. For example, a "Fan Motor" has many records with different costs and quantities associated to it, I would like the query to sum the total quantity and costs of that "Fan Motor".



Thank you,
Kris

[rpeare]

if your query is this simple you shouldn't need the secondary query. You'd just need to create an aggregate query (look for the SIGMA button, looks like a capital E on your toolbar). It will create a TOTALS row in your query which, by default, will say GROUP BY, change the QUANTITY and COST column TOTALS row to say SUM and you should get the result you want.

[krisN]

thanks! that worked