Autonumber help

[rwpetrie]

I know this must sound so simplistic, but I need to be able to set an Autonumber field beginning at a certain number, say 10900, and then index from there, but retain the entire value. I have been able to get the number to appear as "10910" but it is truly recognized (like when doing a search) as only "10."

Can anyone help with this?

 

[Pat Hartman]

Write an append query to append a row with a number one less than what you want the autonumber to start at (this is explained in help by the way).

INSERT INTO YourTbl( YourAutoFld )
SELECT 10899 AS StartValue;

Once you have inserted the next row, you can delete the dummy record. By the way, if you have required columns, you'll need to supply values for all of them in the insert statement or Access will not add the row.

 

[rwpetrie]

Thank you