I have set up a table for a small stock contol. In the table I have the following: Initial stock - New stock In - Stock distributed - Rolling Stock.
I want the rolling stock to recalculate itself everytime new books are ordered or others are distributed. I can get it to do this by using the following code but not every time a new record is entered.
=[Initial Stock]+[New Stock]-[Distributed]
This only works on the first input. When I enter a new record Iniitial stock and new stock start from Zero.
Can anyone help me sort this out please
I want the rolling stock to recalculate itself everytime new books are ordered or others are distributed. I can get it to do this by using the following code but not every time a new record is entered.
=[Initial Stock]+[New Stock]-[Distributed]
This only works on the first input. When I enter a new record Iniitial stock and new stock start from Zero.
Can anyone help me sort this out please