J
Josh Brown
I am currently trying to run a SQL query in Access that updates a field with
a random number with the following query
Update Stats Set Turnover = Int((12 - 8 + 1) * Rnd + 8)
However its not randomizing very nicely.... just gives me the same random
number through all my records when the update completes. (i.e 11 for all
records) How do i initialize the Ramdomize function so it actually produces
a random number for each record it updates.?
Thanks in advance
Josh
a random number with the following query
Update Stats Set Turnover = Int((12 - 8 + 1) * Rnd + 8)
However its not randomizing very nicely.... just gives me the same random
number through all my records when the update completes. (i.e 11 for all
records) How do i initialize the Ramdomize function so it actually produces
a random number for each record it updates.?
Thanks in advance
Josh