Union Query Addition Problems

[Tcurtis]

Good morning, I have a union query that identifies if a part is a L2 or VW part. Each part has a price in the cost field. How do I add up all the L2 parts and the VW parts in a query or form or report to show the totals for each? Example:
L2: $2,000.00
VW: $1000.00

I need this so that I can have just one form and report with both pricings on it but show them separately.

Thanks

 

[Joe4]

You should be able to use an Aggregate (Totals) Query on your Union Query (you can do queries of other queries) to group by your Part Code and sum up your Prices.

 

[Tcurtis]

I have been trying to do this the hard way. Sometimes the simple stuff escapes us........ Thanks so much.

 

[Joe4]

We've all been there!
Glad to help!