Cumulative Total

S

ssimons

I'm needing to write a cumulative total in a query. Tried reading earlier
threads and just got more confused. I need to do the following:

Inventory on hand - Inventory needed - Balance
Balance - Inventory needed - new balance

Can anyone help? Thanks, Sherry
 
S

ssimons

The name of my query is "Components Needed"

Field Names are as follows with the results in the Balance Column of what I
would like to see:

Component Item ID Amount Needed Quantity On Hand Balance
10 50 100
50
10 50 100
0
10 50 100
-50

Thanks for your help. I am new at this if you can't already tell. Sherry
 
S

ssimons

Component Item ID is the Master Product ID. Base information comes from two
separate tables the amount needed is from a linked table named work ticket
and the quantity on hand (which is a static amount) is from another linked
table named item new.
 
Top