Question

Creating a unique identifier

I am trying to create a unique identifier for my records that is

Last Two digits of the year - Record ID

I can't seem to get it right

This topic has been closed for replies.

Ah, refreshing to see a regular post not related to the UI change.

No problem,

Right(ToText(Year([my date field])),2)
& "-" &
ToText([Record ID#])

Sign up