Update Data using Rnd function

[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

 

[Lynn Trapp]

Add the following statement just before the one you have:

Randomize