Previous Record

[honor401]

I have an inventory report that I am given among the fields are
Item, Ship Date, Signed Quantity, Filled-Recvd, On Hand
I am given an initial amount in the onhand field but the fields below that for that item are blank.
What I would like to do is [Signed Quantity] - [Filled-Recvd] and then add that to the On Hand from the previous record and place it in the on hand field..

If it were in excel I would say G2 – H2 + I1
G = Signed Quantity
H = Filled-Recvd
I = On Hand
TIA!
Scott

 

[EdFred]

The way to do it is forget about what you used to have on hand.
Instead build a query that takes the sum of the received in and the sum of the amount shipped out and subtract them.

Why do you need to see a running inventory for every line?

My inventory report is similar to the screen shot of the form.