MS Access auto numbering trying to start with different #?
Posted on 2009-02-13
Need to have auto numbering start with say 1000 instead of just 1. Now
I pulled a script off the web to start it at any number but it still goes
back to 1, ie, I put 999 in the first record but then the next record is
How to get it to go off the last number, ie, 1000, 1001 ...1002 etc?
Note, I'm also appending a table to a table (the first table I'm appending has no
auto number field so that won't effect the auto number table).
And the auto number table has NO primary key (for now).