I want to autonumber records in an Access database so the number contains the year added and a sequential number. I currently have an autonumber format of "H-03-"0000. This is working for 2003, but if I change it to 04 it changes all records. How can I add the "year" function to an autonumber or accomplish an automated year + number for my records? I'm a very basic Access user and have never written code.
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Autonumber containing a date
- Thread starter Silkydog
- Start date
psemianonymous
Programmer
You can't do the date without writing code, unfortunately. You can get simple 'constant' filler letters in autonumbers, but not calculated 'dynamic' values.
Again, you'll need to delve into code to find your solution.
Again, you'll need to delve into code to find your solution.
MichaelRed
Programmer
faq700-184
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
- Status
Similar threads
- Locked
- Question
- Locked
- Question
