K
Kirt84
Sent this yesterday but did not find solution; Any help would be much
appreciated.
I want to have a unique identification number that will be called our
internal batch number. I want it to consist of 3 fixed letters, a number,
letter and auto number. The fixed letters will be 'BNS'. The number will
depend on the month and the letter on the year. For example:
1 = Jan
2 = Feb
3 = Mar
4 = Apr
5 = May
Etc.
A = 2007
B = 2008
C = 2009
D = 2010
Etc.
So if this started today then the batch number will be BNS3A1 then it will
carry on as BNS3A2, BNS3A3, BNS3A4 etc. Is this possible to do? I don’t mind
going in every month and changing the month and year, as long as the auto
number works.
appreciated.
I want to have a unique identification number that will be called our
internal batch number. I want it to consist of 3 fixed letters, a number,
letter and auto number. The fixed letters will be 'BNS'. The number will
depend on the month and the letter on the year. For example:
1 = Jan
2 = Feb
3 = Mar
4 = Apr
5 = May
Etc.
A = 2007
B = 2008
C = 2009
D = 2010
Etc.
So if this started today then the batch number will be BNS3A1 then it will
carry on as BNS3A2, BNS3A3, BNS3A4 etc. Is this possible to do? I don’t mind
going in every month and changing the month and year, as long as the auto
number works.