automated field for stock control, need help, Please

[L'apprentis]

Hello, I have been learning how to use Ms Access in order to design my own Database, I have done quiet a bit but i found myself kind of stuck witth the following issue. My question is pretty simple (I think…) Please, can someone help me?

I need a field that update itself automatically for each record.
For example, if I have 2 initial fields called [Stock balance] and [Quantity delivered]; I need to find a way to have the [Stock balance] updating itself just by entering a value for [Quantity delivered] where [Stock balance (actual record)] = [Stock balance (previous record)] – [Quantity delivered]

I could create a third field Called [Quantity left]
with [Quantity left (actual record)] = [Stock balance (previous record)]
and [Stock balance] = [Quantity left]-[Quantity delivered]

but it doesn’t seem right to create a third field that is equal to an other field just with one record difference.

Anyone with an advice?

 

[The_Doc_Man]

First, please don't double-post. You can access the second thread and delete it if you wish, but leaving it there just confuses everyone.

Now, to business. You are taking an incorrect view of inventory. Search this forum for my name and keyword INVENTORY. Then read over the entire threads to which I offered comments. You can also look for Pat Hartman, GHudson, and several other names that will crop up in the search.

Inventory levels are not static but when you put them in a table, you make them static. When you have read the suggested threads, you will be better able to ask questions about reaching your goal.

 

[Ron_dK]

L'apprentis,

Maybe this thread might give you some pointers.

http://www.access-programmers.co.uk/forums/showthread.php?t=85888&highlight=stock+calculation

 

[L'apprentis]

Thank you very much, This will be very helpfull.

 

[L'apprentis]

Thanks for the advice, I just realised that I was thinking totally in the wrong way. Now that I look at the way I wanted to do the Calculation I almost feel embarassed.
Thanks again,

PS: Sorry for the double post, I didn't mean to do that.
I also think that the "need, help please" is not gonna happen again (just read the sticky post about how to ask a question)