AutoNumber and Random values 1

[jeevenze]

I have one of my fields in the table as Data Type as an AutoNumber. For New Values instead of Increment I have it set as Random. This returns random numbers but some of the values returned are negative .
e.g. -2948573. Is there a way that all random numbers returned are absolute or positive?

Any help is much appreciated.
Thank you in advance

Jeevenze.

 

[JoeMiller]

There is no way that I've ever heard of to make Access not assign a negative number. You'll need to write your own routine to do this. JimmyTheGeek wrote about doing just this in thread181-90208 Joe Miller
joe.miller@flotech.net