Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
YYYMMM-AutoNumber
- Thread starter EasyOnly
- Start date
ProgramError
Programmer
Autonumber is a reference and should be treaded as such. If you require an record id which includes the date I suggest creating a separate field for it.
Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.
Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.
- Thread starter
- #3
ProgramError
Programmer
As I mentioned,do not use the auto number soley for this.
To make the invoice number for you database I would use two fields, a date field and a incremental field (or the auto number field) and combine them when you wanted to display it.
This way you have a reference to the date when the invoice was created and can later search/filter by date using field.
Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.
To make the invoice number for you database I would use two fields, a date field and a incremental field (or the auto number field) and combine them when you wanted to display it.
This way you have a reference to the date when the invoice was created and can later search/filter by date using field.
Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.
- Status
Similar threads
