Query confusion

[mergle]

I have an OrderDetails table that has many records (OrderDetailID's) with like OrderID's (I use autonumbers for all primary keys)...

I have a query that has a calculated field to return material cost extensions (Quantity*Cost*TaxRate) for each OrderDetailID record...

How to sum OrderDetailID records with like OrderID's...

This sum (InvoiceAmount) is for a report that lists OrderID's by Customer...

Thank you for any help!

 

[FoFa]

use a subquery to sum the orderdetail information in your main query.

 

[mergle]

I am not familiar with a subquery...could you explain in more detail and also how I would go about summing the OrderDetail items?

Thank you for your help.