sum function in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003 and I have a report that gathers it's data from a
query. The report isgrouped by date and product. Each product has
items(downtime) associated with it. The total product produced comes out fine
but when I do a sum function to show total produce for all products I get the
wrong answer. It adds the the product produced ofr eachitem associated with
it. Example, product 1 I have 5 units produced and 3 segments of downtime
associated with it and product 2 I have 4 units produced and 2 segments of
down time associated with it. When sumed it shows23 units instead of 9. It is
suming for each time segment.
Any suggestions.
 
You would need to group by Product with a group header. Add a text box in
the group header:
Name: txtUnitsRunSum
Control Source: [Qty]
Running Sum: Over All
Visible: No
Then add a text box to the report footer
Control Source: =txtUnitsRunSum

I am not sure if this matches your specs exactly but you didn't provide any
sample data or actual field names.
 
Back
Top