Autonumber Reset

[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?

 

[Duane Hookom]

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.

 

[GJH]

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