Custom autonumber for batches of records

L

Llyllyll

Thanks to all who replied to my question 'Using Min & Max in combined SQL
statements' yesterday. I went with PC Datasheet's solution and it worked a
treat. Could I ask something else?
For various reasons I have a custom autonumber control who's default value
is set to
'=IIf(DMax("ConsecNo","tblConsec")<1,1,DMax("ConsecNo","tblConsec")+1)'
which works fine, I now need to set another autonumber (Certificate) that
only increments per batch of records i.e. in tblConsec I have four records
for company 'MyCompany' allocated to 2001, 2002, 2003, 2004. These records
are allocated consecutive number 1-4 respectively. I need the certificate
autonumber to remain the same for these four records and only increase by
one when a new company is selected.

Thanks once again,
L
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hybrid Autonumber tag for batches of records 0
INCREMENTAL NBR VS. AUTONUMBER WHEN APPENDING 2
Incremental Record Numbering when appending Batches of Records 0
Prompt user to enter batch number for new records similar to autonumber.. 0
Sorting a Custom AutoNumber Field 9
concatenation of a field value and a counter 3
PMP Certification 1
Problems Loading Large String Array into Array variable 6

Top