autonumber selection in access

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

How Can I increment autonumber when I design the table, I
want to start with my selection
e.g
ID SSN
CBNBAC001 222494563
CBNBAC002 220000069
CBNBAC003 444487878

Is anybody How I design my table in access.

thanks
 
You cannot use an autonumber like this. You'll need to create your own
function to increment the number. On my website (see sig below) is a small
sample database called "AutonumberProblem" which illustrates a solution.
 
Back
Top