Number Generation

R

Rhonda

Anyone know of a quick code that I can sent up an automatic number that will
restart its count at the end of a 24 hour period? Basically wnat the date
with a 001 behind it and it adds 1 for each record that day?
 
A

Alex White MCDBA MCSE

I normally deal with this by changing the number into a string and wrapping
the date into the new number, e.g. 01012005-001 or the other way is a
control table with two fields last_date, counter when checking the control
table make sure that the last_date field is today's date if so increment the
counter field, else zero the counter field and change the last_date to
today's date.
 
Top