K
Kirt84
I have created a unique number on my Form. The name of the field on the table
is ‘BNSBatchno’ and is an auto number.
On the Form I have put the following expression into a text box:
='06' & 'A' & Format([BNSBatchno],"0")
This gives an output of:
06A(auto number)
The first two digits represent the month (06 = June) and the letter
represents the year:
A = 2007
B = 2008
C = 2009
Etc.
I was wondering if it is possible to reset the autonumber back to ‘0’
automatically every month?
Also if possible can the month number change to the appropriate month (if
not this can be done by myself manually).
Help would be greatly appreciated.
is ‘BNSBatchno’ and is an auto number.
On the Form I have put the following expression into a text box:
='06' & 'A' & Format([BNSBatchno],"0")
This gives an output of:
06A(auto number)
The first two digits represent the month (06 = June) and the letter
represents the year:
A = 2007
B = 2008
C = 2009
Etc.
I was wondering if it is possible to reset the autonumber back to ‘0’
automatically every month?
Also if possible can the month number change to the appropriate month (if
not this can be done by myself manually).
Help would be greatly appreciated.