How to Make Autonumber begin from specific point?

[ya5irha55an]

Hi, I am hoping someone can help with this problem.

I have a table which has an autonumber field, set to increment by 1. I would like this to start not from 0 but from, say 1000. Is this possible? Thanks in advance!

 

[neileg]

You are suggesting that this field will have a meaning to the user. The behaviour of autonumbers means this is not a good idea. It is preferable to create your own incrementing number based on DMax(). Do a search in these forums for more info.

 

[ya5irha55an]

Thanks, thats works perfectly!