AutoNumber/ Generate specific ID Numbers

[QA_Compliance_Advisor]

We use an ID number to track changes in documents. Which normally denotes as "yy/###", where yy is the last 2 digits of the year and ### notes the number in a sequential sequence.

is there a way to program Access to generator the tracker which changes the 'yy' to the year it is generated. i.e. currently it is 2014 and I would like it to generate "14/001" but when 2015 comes about I would like it automatically denote 2014 to 2015 to display "15/001"

any one have any idea, I did try format properties in design view but I could only get the yy to change.

[ItsMe]

Have you tried using the Year() function?

[ranman256]

i = i + 1
ID= format(date,"yy") & "/" & format(i,"000")

[QA_Compliance_Advisor]

I have not tried the year funciton

[QA_Compliance_Advisor]

i = i + 1
ID= format(date,"yy") & "/" & format(i,"000")

this does not seem to be counting.