Calculated Total In Query

I

Irish Hulk

Access 2003. I have a schedule query that pulls all orders from tblORDERS
and sorts them by delivery date. I need to show the price for those orders
by calculating the total of all the related records in tblORDER DETAILS.
Every time I try and include the ORDER DETAILS on my query it pulls up the
related ORDERS record multiple times causing repeated records. tblORDERS
(one) to tblORDER DETAILS (many) relationship.

Any input will be much appreciated.
 
D

Duane Hookom

Depending on what your specifications are, you should be able to change your
query to a totals/group by query.
 
Top