can Access increment?

[Sean Benjamin]

I'm trying to find out if Access even has the ability by itself to increment
for me like as an inventory database.

For instance, I want a form that will allow me to input a product name (or
ID) and then input a positive or negative integer. Then Access use that
integer to modify the running total of that product in the background.

Then of course I'd like to be able to see that running total somewhere, or
at least run a report to display it.

I've tried some books and the help files, can't find anything suggesting how
to do this.

Thanks in advance!

-Sean Benjamin

 

[Allen Browne]

Sean, this is quite a big question. For starters, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html