can Access increment?

  • Thread starter Thread starter Sean Benjamin
  • Start date Start date
S

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
 
Sean said:
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
Click to expand...

Sure it can. The best solutions are likely to involve VBA programming
however. You might be able to do what you want using tricks in queries, but
I would think the results would not be a good GUI.
 
Back
Top