4 digit auto number

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

Guest

I am looking for help to start off my "Project Number" field with and auto
four digit number, Can someone please help?
 
raj said:
I am looking for help to start off my "Project Number" field with and
auto four digit number, Can someone please help?
Click to expand...

AutoNumbers are generally not a good idea for anything but "behind the
scenes" usage, but to do what you want you can use an append query to append
one row to your table with the value 999 for the AutoNumber field, then
immediately delete that record afterwards. The next record added after that
will be 1000.
 
I think I understand but since I'm a newbie, can someone explain or provide
an example? Thank you!
 
Raj,

Using the query designer...
1. Make a new query. Do not add any tables to the top panel of the
query design window.
2. Type 999 into the Field row of the first column of the grid.
3. Make it an Append Query (select Append from the Query menu), and
nominate your table as the table to append to.
4. In the Append To row in the first column of the grid, enter your
Autonumber field.
5. Run the query (click the toolbar button with the red ! icon).
6. Close and don't save the query.
7. Open the table datasheet and delete the newlay appended record.
 
Back
Top