Hi All,

I have Access 2000 Database. In my table, I allocated the first column(Index Number) as autonumbering format with incremental mode. How can I limit my database starting from index number 10 to 99? I need to limit the field to only 2 digit only. Hence, from 99, it will go back to 10 and not zero. Please help.

Rgds,

James

You can't reuse index numbers. They must all be unique, so you can't run from 10 to 99, and then back to 10 and start over.

If you are trying to do this in another field, then you can work this out with code. But since the Primary Key must be unique, this will never happen the way you want here.

mmcdonal

Autonumbers are not meant to be used for any reason other than tagging a record with a unique index. Therefore, if you "need" a number "to be something" you should create a field for it that's not an autonumber field and populate its value with code, e.g. an AfterUpdate event.



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Just out of curiosity, why are you going from 10 to 99 and back to 10 again?

You could have your 10-99 value propegated based off of the autonumber. For example, the mod operator (AKA modulus) can be used to transform your data. The formula below will return an integer 10-99:

result = ([AutoNumberField] Mod 90) + 10

MOD is a function available in the query expression builder, and you can also use it in code (VBA).

Regards,

Bonnie