Autonumber, only positive values

  • Thread starter Douglas Sanders
  • Start date
D

Douglas Sanders

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

Thanks,

Doug
 
D

Douglas J. Steele

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.
 
D

Douglas Sanders

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
 
Top