Autonumber to start at 500

[Chimp8471]

i am sure i have asked this before but have looked back through my posts and can't see it....

i need the autonumber to start at 500 instead of at number 1.

i am also looking at maybe preceeding this with a letter so that it would start at

A500

 

[dcx693]

How to Use an Append Query to Set Initial Value of an AutoNumber Field

This might be interesting: How to Create a Multiuser Custom Counter (95/97)

 

[Chimp8471]

ok thanks, i thought i could put something in the table design thing so that it would do it from there.

but will look at your option