Generate new lot number

[markcharleston]

I need to create a database that will generate a new lot number when a button is pressed. Our lot number format is:

03U01 where 03 represents the current month, U represents the year (2007=U, 2008=V, 2009=W, etc.)and the final two characters are a sequential number, starting at 01 and going through 99. I can generate the month and year using the Date() function and Select Case. I'm not sure how to tie them together with the next sequential number for that prefix. Any suggestions would be greatly appreciated.

 

[Craig0201]

You need a DMax lookup function.

 

[Eupher]

Hiya, markcharleston,

A question... will your DB be multi-user? Or stand-alone? It makes a difference with respect to generating a unique identifier such as your lot number.

Ken S.