Number Generation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

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

Show me your highest mileage HDD? 0
Auto Generate Primary Field Value 5
Extraction of Dates 4
Count Number Of Days That Had One Or More Records 3
How do I reset autonumbering without affecting previous records? 1
Auto picking numbers 5
ID Number Format 6
Finding the date of the first day of the week using "ww" to ID Wee 3

Back
Top