create counter by VB in Access 2007

[shad_eng]

Hi..
Who can Help me I want Create counter in access 2007 by vb

for example today we have 1000 goods in my sale goods company

when I sale 30 goods number of goods in my company equal to 970 then I sale 40 goods at this time number of goods equal to 930 as the same until number of goods equal zero

 

[KenHigg]

So you have Goods Item X and you have 1000 of them. Then you may also have Goods Item Y and you may have 500 of them?

 

[JamesMcS]

In a transaction like that, all you need to do is run an update query to say "Stock level=stock level - sale quantity". Easy.

Then when you buy more stock and add it into the database, run another update query to say "Stock level = stock level + purchased good quantity"

 

[shad_eng]

Hi...

if we have a safe box in an company, and we want to do an automation account to my box when we bought some thing and withdraw money from the box then program should make decrease money from the box automatically, while if we sell some thing then the program should add the money to the box.

 

[KenHigg]

So now I'm lost... All yours James...

 

[JamesMcS]

Isn't that what I explained in my previous post? All you need is to trigger an addition (when something goes in) and a subtraction (when something goes out), i.e. + and - operators.