Unique number

[Guest]

I want to create an internal batch number for our company. I want it to
consist of the month number, year as a letter followed by a sequential number
(auto number).

A = 2007
B = 2008
C = 2009
Etc.

Therefore, if the date was 10th April 2007 then the number would be:

04A1

‘04’ being the month of April and ‘A’ being the letter for 2007. The ‘1’ we
are assuming that this is the first record that is being produced. I do not
require this to be displayed in the table just the Form. The field should be
in the form of an Auto number. Please can someone help??

 

[Joseph Meehan]

I want to create an internal batch number for our company. I want it
to consist of the month number, year as a letter followed by a
sequential number (auto number).

Note: Auto numbers are not designed to create unique numbers. Those
numbers are usually sequential, but they may well not be. You should not
rely on autonumber to produce sequential numbers. They are not really
intended for human consumption. You can use the DMAX function to create a
unique sequential number.

A = 2007
B = 2008
C = 2009
Etc.

Is there any chance at all that the data information may change for an
existing record? and is the date stored in that record The question here is
would it be better to store the result or to re-compute it as needed.

 

[Guest]

Thanks for the suggestion

Please can you tell me how the DMAX function works?