How do you set the range of allowable numbers for an autonumber fi

[mshogfan]

I am using Access 2002. I'm working on a database for inventory. There will
be 4 different databases that periodically will be combined. I need an
inventory number to be automatically generated. I was going to assign a
range of numbers for each location, so there would be duplication.

 

[Rick B]

Auto number is not intended to create 'useful' numbers. They are simply
behind-the-scene numbers.

Based on what you have said, you would wnat to manually (or through code)
create a stock number as the part was created.

I would not use an auto number for your application.

Rick B