Creating a unique ID number in a form

[Guest]

I am creating a form that will pass the data to an Access database. I want
the form to have a unique ID number field that is automatically created when
I submit the form. I would like the number to be of the format
200512141,where the first 8 numbers are the current date, and the last number
starts at 1 and each new entry increments by 1. Any ideas on how to
accomplish this?

Thanks in advance.

 

[clintonG]

What platform is your web server?
Why in the form? Depending on your page and form submittals using the form
for this type of identifier could lead to end-user modification. It may be
better to do this on the server. I've done a lot of this type of task for
various projects. Its not a "here's how its done" code snippet. If you want
to talk turkey to hire it out I'm all ears...

<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/