Calculated Total In Query

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacked vs Multiple Inner Joins 8
Query based on 2 related tables 1
Calculated Field in Query - Date Format 5
Returning multiply entries on Query 7
Values from multipule records in 1 record 4
Delete main record that has no subrecords 7
sorting query by calculated field 9
Record Number in Query 2

Top