|
|
|
#1
02-10-2006, 12:12 PM
|
|||
|
|||
Need help with an auto number
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 
|
|
#2
02-10-2006, 12:21 PM
|
|||
|
|||
|
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
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reset page number and total page number for each group | lisadailey | Reports | 1 | 03-12-2009 07:55 AM |
| Sum Of Positive Number and Negative Number | maysamab | Reports | 1 | 10-20-2008 02:06 PM |
| Auto Scroll in a Form | delliott777 | Forms | 0 | 05-31-2008 05:02 AM |
| Auto Numbering | rkruczk | Forms | 0 | 10-09-2006 02:25 AM |
| Auto-Create a Table | Mxcsquared | Forms | 3 | 01-28-2006 08:36 PM |
Windows 7 
Access 2007 (version 12.0)
Linear Mode
