Recent content by jonarnott

  1. J

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

    Thanks jdraw Will get reading asap
  2. J

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

    Hi Pat, Thanks for your reply, i knew this wouldnt be easy! Looks like im gonna be doing some bedtime reading :P OK so to clarify, i should retain the PK as autonumber, 1, 2, 3 etc but add another field, ProjectCode or similar, and have that set as unique? The expression will then deal...
  3. 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