random number generation

[DigiTomi]

Hello,

I have this query:
SELECT UNIT.Code, Rnd() AS Expr1
FROM UNIT;

The problem is that in the Expr1 field all the numbers are the same. I would like to have random numbers that are different for each record (generate new random number for each record)

Thanks for your help
Cheers

 

[pdx_man]

I found this:

http://www.fontstuff.com/vba/vbatut02.htm

 

[DigiTomi]

Thanks for your help