positive random AutoNumber???

[Guest_imported]

hi all,
i am trying to use AutoNumber to create random membership ID numbers......everything would be great except for the fact that Access is generating negative numbers some of the time.......how do you format random AutoNumbers to be positive only??? thanks in advance for your help!
mrsand

 

[tlbroadbent]

There is no way to create only positive Random Autonumbers. You should be generating your own membership IDs. Autonumbers should NOT be used for maningful data that will be displayed to users. Terry L. Broadbent - DBA

http://tlbroadbent.home.attbi.com/index.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers."

 

[archery]

I agree with the previous post re NOT using Autonumber fields for "meaningful data".

If you need to generate random numbers look up the RND function/statement under Access help

 

[Guest_imported]

thanks for the responses, i will look into RND, but most likely will generate our own membership IDs.....thanks much for your help!