Autonumber

[Guest]

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)

 

[Guest]

Autonumbers are not for generating sequences, but to provide unique
identifiers that should have no meaning to users. Ask yourself this: Does it
matter if autonumbers are assigned sequentially, or at random? If it does,
then you shouldn't be using Autonumber. There are other methods for
controlling sequential numbering.

 

[Guest]

What is the other method??

 

[Guest]

Simple approach: split the key field into 2, say DateID, SuffID.
DateID = Date()
SuffID = NZ(DMax("SuffID", "YourTableName", "DateID=Date()"),0)+1
Combine these two fields for display on forms & reports.

More comprehensive solution: se
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Semaphore.mdb'