new serial number for each year

A

Al Camp

I'm going with Ed Warren on this one... for those reasons he cited.
Given that you capture the date when a record is created (ex. a [DOC] field
(Date of Creation)) you can always concatenate the year with a "legitimate"
(unique number only) IDNo.
=Year([DOC]) & "-" & ID
for "display" purposes.
 
Top