AutoNumbers

[Vivian Galligan]

Please help with two items related to autonumbers:
1) I know I can add leading zeros to obtain a four digit
autonumber but can't remember how to do it.
2) I have created a FullCaseNumber joining an autonumber
case field and the year part of a date reported field but
I would like to annually reset the autonumber case field
back to zero on January 1st. Any ideas?
I don't write code.
TIA

 

[Hugh O'Neill]

Please help with two items related to autonumbers:
1) I know I can add leading zeros to obtain a four digit
autonumber but can't remember how to do it.
2) I have created a FullCaseNumber joining an autonumber
case field and the year part of a date reported field but
I would like to annually reset the autonumber case field
back to zero on January 1st. Any ideas?
I don't write code.
TIA

May I suggest you use some other method of obtaining numbers instead of
Autonumber? What Arvin has suggested is equally applicable to a
different source of numbers.

Autonumber is designed only to provide a unique identifier for records
in a table. This is used internally by Access in building relationships
between tables according to your design. The actual values that
Autonumber delivers are unimportant and should never be exposed to
users or have any external meaning at all. Depending on the design and
use of the database, Autonumber will develop gaps, become random and go
negative.

For any number series that you want to control or have available
externally, you must design your own. There are several schemes
available depending on what you want to do.

hth

Hugh