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
 
Back
Top