Hi Again,
I must say i am Happy to be a part of "THE Scripts!"
Once again I need 2 know. Is it possible to create a field in a table of a Access Database titled Customer ID that will auto number for example "5th customer for 2007" This is how i want it to display 005/07, so that will be thier "customer identification"
I hope who ever responds, will understand exactly what i am asking.
Yours Replies will be greatly appreciated
need2know
It is possible to generate this value, but it won't be an AutoNumber, or even a Number at all, and for now you'll manually have to Reset this value for the 1st Customer of a New Year. The value to which you are referring must be Text, and the next value in sequence can be generated by (assuming Table Name is tbtTest);
-
Format$(Val(DLast("[Customer ID]", "tblTest"))+1, "000") & "/" & Format$(Now(), "yy")
-
NOTE: If the last [Customer ID] for 2007 was
023/07, the next autogenerated ID would be
024/07.