Search results

  1. J

    How do I format ID field with date prefix and have the ID restart next year?

    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...
Top Bottom