I am new at Access and have set up an invoice database. I have the invoice # setup as a auto number but I need the Ivoice number to start at at Invoice number 700000.
How can I get the auto number to start at 700000?
Thanks
I am new at Access and have set up an invoice database. I have the invoice # setup as a auto number but I need the Ivoice number to start at at Invoice number 700000.
How can I get the auto number to start at 700000?
Thanks
Based on a tip from: http://www.mvps.org/access/tables/tbl0005.htm
1. Create your table, but only do the ID field, defined as AutoNumber. Do not enter any data before moving on to Step 2!
2. Execute this query:
INSERT INTO YourTableName (AutoNumFieldName)
SELECT [EnterStartingNumber] AS Expr1