Originally posted by HelpMePlease
I have a autonumber field in a table.
The number starts from 1 and increments by 1 on each entry.
What I want to do is start the number from 1000 and then increment by 1
Does'nt sound unreasonable to me, can someone tell me how it is done?
If you run a search on Access Help it give you the solution, but here it is also. Create a Temporary table, call it Temp and give it one field called Number. Change the field type to Number and leave it Long Interger. Open the table and enter 999 and close. Create a new query for your table Temp. Change it to an Append Query setting the field Number as the Field and whatever your AutoNumber field name as Append To. Save and close. Run the query and it will append to your table you want to set. The next entry you make in that table will be 1000.