Need some help on summing multiple fields in a query

illy2k

Registered User.
Local time
Today, 06:01
Joined
Apr 21, 2003
Messages
51
I have an order entry system I am designing for a client. There is and order ID number associated with every product that is ordered. So they can have multiple products with the same order ID #. Also labor orders can be ordered on that same order form, and these too are given the same ID #. So every entry that is entered has products and labor with the same order ID #. When I try to create a query to show the total cost, when I have lets say one labor order and 3 product orders on the same order ID# the labor order shows up 3 times on the query for each one of the products ordered. All I need is total money for labor and a separate one for total products ordered. I need under one order ID# multiple products totaled and on one line and multiple labor expenses totaled and on one line.
 

Users who are viewing this thread

Back
Top Bottom