sum function in reports

[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.

 

[Duane Hookom]

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.