I have a table I am trying to create with a unique Pk
Table fields
JobID---PK
JobDate
I would like to have the primary key be a combination of increment
number starting with 001 and year and month such as 510=5 of year and
10th month
Each month I would like the increment number to reset itself so
november 1 it would start at 511-001 the December would be 512-001
I did this in the form using
Right(Format([Date],"yyyy"),1) & Format([Date],"mm"
but cant see how to do it in a table
any help is extremly appreciated