I set up users in a database on a daily basis. There has been a recent change where I need to assign each of them to a number between 800 and 899, in sequential order. How can I do this, using VB or ACCESS, so that the variable isn't lost when the application is closed? In other words, if I add a user today and it's assigned 820, when I close the program, and reopen it tomorrow, I need it to pick up where it left off with 821 as the next assigned number.

ScottGem

The assigned number should be stored as a field in a record. You can use the DMAX function to pull the last assigned number and increment by one.

andy5179

Can I just use a query to update the field? Its still a little fuzzy.

andy5179

But when the number gets to 899, I need the next one to reset at 800. How can I accomplish this?

ScottGem

Why would you need to reset? What is the purpose of this number? it can be done, but I'd like to understand more about the application first.