Inventory Balance

[Don]

Hello everyone,
I have a form which I display in datasheet view for the purpose of
being a parts inventory sheet.This form is used as a subform for several
different items. My question being, is there a way of displaying a running
balance in Access the way that Excel can. For example, on the first row I
have 10 received, 2 disbursed, and a balance of 8. On the next row, I have 0
received, 3 disbursed, and a balance of 5. However, the balance field of the
previous row would still show 8. Is this possible to do in Access. Any info
would be greatly appreciated. Thanks again. Don

 

[Tom Wickerath]

Hi Don,

There is an odometer example in the Microsoft Knowledge Base, which I think can be adapted for
your needs.

Referring to a Field in the Previous Record or Next Record
http://support.microsoft.com/?id=210504

Tom
____________________________________


Hello everyone,
I have a form which I display in datasheet view for the purpose of
being a parts inventory sheet.This form is used as a subform for several
different items. My question being, is there a way of displaying a running
balance in Access the way that Excel can. For example, on the first row I
have 10 received, 2 disbursed, and a balance of 8. On the next row, I have 0
received, 3 disbursed, and a balance of 5. However, the balance field of the
previous row would still show 8. Is this possible to do in Access. Any info
would be greatly appreciated. Thanks again. Don