Sum in Report

  • Thread starter Thread starter NNlogistics
  • Start date Start date
N

NNlogistics

I have a query with 2 tables- tblOrder and tblOrderDetail. The detail
contains all the info about the product (code, quan,tax etc), the order
contains mostly the customer info, however it also contains the Shipping and
handling charge for the order. When I run the query, the SandHCharges appear
on each line. Which is fine there.
In the report, I move the fldSandHCharges to the order level, on the next
level, which is Sale Type I also want to total the SandHcharges for each
order. Say the SandH is $10.00. What I am getting is a total as if it where
charging the SandH for each item in the order. So if I have 3 orders with 5
items each, the total is coming as $150.00 (15 X 10) instead of $30.00.

I think my problem starts way back at the query, Maybe or not. Or it can
be adjused for in the report, Maybe.

Any ideas?
 
Are you using two queries, one for order and another for detail? The use
form/subform (order/detail) linked Master/Child on OrderID field.

SandHCharges will appear once per order. Use the Sorting and Grouping with
footer to total charges.
 
Thanks Karl. I created a totals Query and used DSum to give me the S and H
charges. Thanks for the feedback
 
Back
Top