creating a unique number without using <autonumber>

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

Guest

I need to store it as a number and if I do time, tomorrow, if I
create a record at the same time, I will have duplicate entry - which won't
work. I have to always have a unique number (when it is created for the
first time).

I want to store (10/10/2005 14:05:26 (for example - knowing that changes
every minute) as a unique, never again to be duplicated number. Is that
possible?

Or if there is another way to create a unique number without autonumber
 
As you've already been told, the Now function will give a number that
represents both date and time.

Are you positive, though, that you'll never have more than one record in a
second? Also, are you sure that your clock will never get reset, so that
it's possible for the same date/time to occur?
 
BLTibbs said:
I need to store it as a number and if I do time, tomorrow, if I
create a record at the same time, I will have duplicate entry -
which won't work. I have to always have a unique number (when it is
created for the first time).

I want to store (10/10/2005 14:05:26 (for example - knowing that
changes every minute) as a unique, never again to be duplicated
number. Is that possible?

Or if there is another way to create a unique number without
autonumber
Click to expand...

Date time is stored down to the second.

However I suggest using DMax function.
 
Back
Top