Hi all,
I am new to access and its intricacies!
I assume this question will have already been asked.
I have a table which will contain project information, and want the ID field, which auto assigns a unique number to each record, to be formatted like this P12-001, where 12 = the last two...