Chage the starting value of an AutoNumber field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to change the starting value. I've followed the help program but
getting "About to append 0 rows" and it doesn't work
 
Bad idea. I suggest you read the post on why relying on autonumbers is bad -
omissions in sequence.
You did not say where you wanted to start the autonumber. If you qant to
start at 50 then create an append query with two fields.
XX: 49 YY: "Test"
Set the ZZ to append to your autonumber field and YY to any text field.
Run the append query.
 
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

Append query to change the value of an autonumber field 2
Append query - Append to table with Autonumber field 2
Reset autonumber 2
Append to Table with Auto Number 2
Autonumber restarting after compact and repair 4
Change the starting value of an AutoNumber field 3
Combine two fields in a query to get a unique third one. 4
Calculate next 5 numbers from table field 2

Back
Top