Limit Auto Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to limit an Auto Number field to 3 places (999) and then start
over at (001). The field size that I am exporting to is only 3 places. Or
can I format to only 3 places.
 
No. It then would not be a unique number within the database.

You'll need to create your own numeric field to hold the desired 3-digit
number, and then put correct numbers into that field by code or other means.
 
Is there a way to program and autoumber field? I am thinking in the default
value I would add 1 to the value of the previous record and set up an IIF
statement to reset it after 999.
 
My gut says don't export the autonumber field at all if you've got a
limitation like that. It won't do too much good anyway, and usually when
you are exporting something an autonumber field isn't relevant anyway.
Perhaps if you told us why and what you are exporting it to.

If you must do this, I would say leave your autonumber field alone, and
before you export use a query that adds a calculated field with an iif
statement to keep it between 1 and 999.
 
If you just want to export a three-digit number, why not use a calculated
field in a query that takes just the last three numbers from the autonumber
field's value:

My3DigitNumber: Right([AutonumberFieldName], 3)

What you seek to do, as I said before, is not possible with an autonumber
field.
 
Thanks for your help. I also came to this solution.

Ken Snell said:
If you just want to export a three-digit number, why not use a calculated
field in a query that takes just the last three numbers from the autonumber
field's value:

My3DigitNumber: Right([AutonumberFieldName], 3)

What you seek to do, as I said before, is not possible with an autonumber
field.
--

Ken Snell
<MS ACCESS MVP>

nathan a said:
Is there a way to program and autoumber field? I am thinking in the
default
value I would add 1 to the value of the previous record and set up an IIF
statement to reset it after 999.
Click to expand...
Click to expand...
 
Back
Top