Autonumber, only positive values

  • Thread starter Thread starter Douglas Sanders
  • Start date Start date
D

Douglas Sanders

Is it possible to use the autonumber (random) and only get positive numbers?

Thanks,

Doug
 
No, it's not possible.

However, if you have such a requirement, perhaps Autonumbers aren't
appropriate. An Autonumber has one purpose only: to provide an (almost
guaranteed) unique value that can be used as a primary key. Negative numbers
fulfill that purpose just as well as postive ones. No meaning should be
associated with the value of an Autonumber field. In fact, it's rare that
the users should even see the Autonumber value associated with a record.
 
Thanks, I'll have to use some VBA programming to do the job.

Need to create some reference points for a series of double-blind
experiments.

Thanks again,
Doug
 
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

Random Autonumber 4
Remove Negative AutoNumbers 2
change a random-valued autonumber field 1
negative Autonumbers 5
Table Foreign Key. Access 2003, Windows XP. 7
Autonumber field changes to random from sequential 3
Re-number an Autonumber 4
AutoNumber vs. Natural Primary Keys 6

Back
Top