I need to generate a file number which will consist of the date, formatted as yymmdd and a running number of records for the date, for example, 02062501, 02062502, etc. I tried using:
Count(DLookup(field, "qry", Date())),
on the form's before insert event, but it didn't work. Any ideas?
Thanks,
Judy
Count(DLookup(field, "qry", Date())),
on the form's before insert event, but it didn't work. Any ideas?
Thanks,
Judy