Custom Unique Identifier

[sstrode]

What I am trying to do is in access make a auto-generated indexed key that will be used to track the flow of a product. I want to be able to reference this number later on so what I would like to do is have this number auto-generate the month, and tack a number on to the number. what I want 09001 (09-September 001-first reference number) or 0914001 (month, year autonumber). I know how to do a preset prefix but I want this to grab the current month. any suggestions.

[June7]

Constructing custom unique IDs is a common topic. Search forum and Google.

Here is one for starters
https://www.accessforums.net/access/...ers-21361.html

[orange]

Don't overbuild intelligence into a code/identifier. You will have fewer issues by adhering to the KISS approach --1 fact -->1 field.

You could have a CreateDate and use Date() to populate same, and if Time was significant, use Now() instead of Date().
You may wish to read this regarding autonumbers in Access before deciding on how to proceed.