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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoNumber Field Not Populating with Append Query 2
Autonumber restarting after compact and repair 4
Append to table with 2 fields in Primary Key - last is an autonumb 1
COUNTIF 1
Create table query... want to insert autonumber column 3
Append Query: SQL to add a new record? 7
Query with autonumber 1
auto increment 3

Back
Top