PINs are suppose to be confidential and no one is suppose to know anyone
else's PIN. This being the case, why would the PINs need to be incremental?
You're just making it hard on yourself. Just use an autonumber starting at
some appropriate four digit number. If you should skip a number, so what!

Steve



"Rev David Bissas" Rev David wrote in
message ...
I am trying to create a unique PIN for members in a table (not the primary
key) that will be 4 digits long, and would like each new entry to be
incremental. I am very new, and would appreciate a detailed instruction
(though I can get around access fair enough). Any help would be
appreciated.