|I am working on a Microsoft Access project and need a validation rule for the job number.|
I need it in the form 09-140
where the 09 represents the current year, and the 140 an incremental number which starts from 1 and automatically increases by 1 with each addition of a new job.
I would like the rule to autofill as I enter information for a new job, and for the 09 to automatically change to 10 when we go into the year 2010 etc.
For the first 3 jobs this year the job number would auto-fill:
and then if there was not a job until 2010, the next job number would be:
Is this possible?
Thanks in advance,