Custom ID - Access

[khaugen]

I am creating a tracking database in which I need a Custom ID table field which auto assigns a unique number to each record, to be formatted like this 2500-2021-0001, where 2500 is a fixed/constant, 2021 is the year the record was created and 0001 is the sequential record number.



Thank you

khaugen

[ssanfu]

Check out BaldyWeb - Custom Autonumbers/sequential numbers

Also, do a search on "Custom Autonumbers" .

[ranman256]

use an autonumber field and a year field. combine them
"2500-" & [year] & "-" & [autonum]

zero programming.
But if you want starting a 1, then you gotta do it the hard way and program it.
I would do it the easy way.