Update Data using Rnd function

  • Thread starter Thread starter Josh Brown
  • Start date Start date
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
 
Back
Top