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.
 

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

Back
Top