Autonumber Reset

  • Thread starter Thread starter Gareth
  • Start date Start date
G

Gareth

I have a table of data with 2 columns YEAR & ORDER NUMBER.

Both fields are indexed. ORDER NUMBER is an autonumber
field and YEAR is a date field with yy formatting.

At the change of year I would like to reset the ORDER
NUMBER field to 00001.

Is there anyway of doing this without archiving the
exsisting data?
 
This is not possible. An autonumber should be used as a unique identifier
only. I rarely if ever display the number on a form so users don't ever know
what the value is and don't care if it is 345 or 9203423.
 
SEE:
the post "Autonumber in a specific format?" June 23,
below for an Autonumber alternative. Sometimes you/your
users must have a record code number which means
something to them, and this may be what you are looking
for.

regards
GJH
 
Back
Top