Remove Negative AutoNumbers

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Is there a way to have only positive numbers in an
AutoNumber field set to random?

Thanks in advance,
Matt
 
No. Random means random and the random generator is going to go through the
full range of long integers.

Now, ask yourself the question, "Why does it matter"? All an AutoNumber
field does is provide you with a unique identifier for a record. It should
not matter what it's value is. If you really need to display it to your
users as a positive value, however, you can use the ABS() function.
 
Back
Top