K
Kirt84
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??
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??