how to add and subtract in access?

[Shan Ray]

just want to ask if what's the expression on how to automatically get the value of balance where every time i input a value at qty added, it will be automatically added to the last value of balance and at the same time when i input value on qty taken it will be subtracted to the last value of balance and place the output on field balance..thanks..see the attached photo for more info..

[TheSmileyCoder]

Just because access' table at a first glance looks like excel rows and columns, the 2 are not alike. The way you are proposing to use access shows a lack of understanding of what a relational database is.

If you want some help on how to control stock on hand, you could start by looking at this link:
Allan Browne's inventory

[Shan Ray]

oh im so sorry...i just use the excel as my example but its just the same with what I will be doing in access and i dont know what expression to use...i just want the last entry of balance to be subtracted to Qty taken or to be added to the qty added...thanks..

[TheSmileyCoder]

There is no simple answer. Look at the link I gave you.

[Shan Ray]

..thanks for the link you've given but i really dont know how to hardcode..i just want to know the expression or the likes on getting 'solution'..thanks..

[Rabbit]

Given what I see in the picture, there is no expression that can calculate this in Access. You will need to use code unless you make modifications to the data structure.

[Shan Ray]

thanks for the reply...you see i dont know how to code and I could really appreciate if your kind enough to help me...thanks...

[Shan Ray]

...well here is an access example...hope you could help me out..

[TheSmileyCoder]

The problem is not that we don't understand what you want. You need to understand that we are not able to give you what you want in any reasonable timeframe. Even if me or another did whip something up for you, you lack the knowledge to understand and implement it. At best we could make something similar to the first link I gave you which you have allready admitted that you didn't understand.