Calculating Running Totals

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

Guest

I have a table that has receipt quantities for various items. Most of the
items are entered more than once, becuase shipments are received on different
days.

How do I run a report or query that will total each individual items
received quantity to date?
 
SHILLS said:
I have a table that has receipt quantities for various items. Most of the
items are entered more than once, becuase shipments are received on different
days.

How do I run a report or query that will total each individual items
received quantity to date?
Click to expand...


You will need to group on the item id field. If you can do
this in the report using Sorting and Grouping, then just use
a text box in the group footer section bound to the received
item field and RunningSum set to Over Group.

If you can't live with that, then create a Totals query that
calculates the desired total and join the query to the
table/query used as the report's record source.
 
Back
Top