K
Kirt84
I have a Field called ‘Batch No’ which is set as an Autonumber and is the
Primary Key in my Table. On my Form I have set the control source of the
Batch no to:
=Date() & Format([BNS Batch no],"0")
This is so it will output the current date followed by the Autonumber every
time a new record is started (e.g. 25/10/20061, 25/10/20062, 25/10/20063,
25/10/20064 etc). Is there any way where I can get the Autonumber to start
again from ‘1’ when a new day starts? So the next day will be: 26/10/20061,
26/10/20062, 26/10/20063, 26/10/20064 etc)
Primary Key in my Table. On my Form I have set the control source of the
Batch no to:
=Date() & Format([BNS Batch no],"0")
This is so it will output the current date followed by the Autonumber every
time a new record is started (e.g. 25/10/20061, 25/10/20062, 25/10/20063,
25/10/20064 etc). Is there any way where I can get the Autonumber to start
again from ‘1’ when a new day starts? So the next day will be: 26/10/20061,
26/10/20062, 26/10/20063, 26/10/20064 etc)