Suming Duplicate Records in Union Query

[Sqnwk]

Hello

(Example of my data)

Order ID Customer ID Purchase Amount
1 17 $14.95
1 17 $7.35
2 21 $11.90
3 27 $64.80


3 27 $31.13

I'm new to access and could use your assistance. I have two tables with pull in data. What I'm looking for is a query that would combine the customers purchase and sum the purchase amount field. The tables are unioned as some customer data is in one table but not the other and joining them excludes some of this data. Ultimately I would like to see is

Order ID Customer ID Purchase Amount
1 17 $22.30
2 21 $11.90
3 27 $95.93

Any assistance would be greatly appreciated.

Thanks

[June7]

Use the UNION query in a GROUP BY (Totals) aggregate query. Or use the UNION as RecordSource for a report and use report Grouping & Sorting with aggregate calcs in header/footer section. This will allow display of detail records and summary data.