Only positive values in random auto-numbers.

[insixt]

Hello all .


I have a table where I would like the primary key to be automatically generated by Microsoft Access. At present I have the field set to Auto Number(Random) and Long Integer. Unfortunately this gives me both positive and negative values. How can I get Access to just return positive numbers (I do not wish for the number to be incremented - I need random.)


Thanks for reading and I hope you can help!

[dcrake]

What difference does it make if the numbers are pos or neg? PK's are PK's and are only used internally to identify relationships. And why must you have ramdom?

David

[insixt]

Cheers for your reply. I just realised I can use negative values after all! Thanks again.