Random Number (Different) for each record

[Sunwriter]

Hello:

I need to update a field in a table with a random number between 1 and 9 "for each record". Example:

RecordNum NewField
1 5
2 7
3 9
4 4
5 1
6 5
etc.

When I attempt to use the rnd() function, I end up with the "same" random number for every record.

Thanks in advance for any assistance,

Jeff

 

[PHV]

Use Rnd(RecordNum)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886