How to set an autonumber to an specific value?

[Secue]

Hi,



I'm working on a database, I have an autonumber field. I will use this field to provide to teh user a ticket number. Currently this sytem is working on excel and this number is actually rounding the 3000 records, How can I set the autonumber field to start for example on the number 3100 and not on the number 1?

Thank you.

[June7]

Options:

1. http://support.microsoft.com/kb/209696

2. calculate the value in queries and use the calculated field for sort and filter purposes
[TicketNum] + 3000

[John_G]

My opinion - but since you want your "autonumber" to have meaning to the users, and be more-or-less under your control, I suggest that you not use Autonumber at all; instead use VBA to generate a new number whenever you need one, based on the current maximum. Autonumber can easily lead to gaps in the sequence, for example when a user cancels a new record.

John