Custom Autonumber 1

[LakotaMan]

I'm trying to figure out a way to create an autonumber field that combines the current date with sequential numbers, and then starts the sequence again for the next entry date, i.e.:

07010401
07010402
07010403
07020401
07020402
07020403
07020404
. . .etc.

I'd like to be able to do this on the table level and then use this as the primary key. Further, I'd like it to be the default value, but not the only possible value.

Does this sound possible?

Thanks in advance,
Tru

 

[MichaelRed]

faq700-184,

with some of your own (custom) modifications




MichaelRed
mlred@verizon.net

 

[HemanSkeletor]

That's a dynamite faq/solution, michael.