How do I create a query in MS Access 2007 to select a random Value?
Posted on 2011-09-15
I have tried the below but am not getting anywhere. Last week the below formula worked,b ut now it doesn't. Is there a better way to random a formula for a MS Access Query to pull for me a random value?
Int ((6 - 1 + 1) * Rnd + 1)
would return a random number between 1 and 6
Int ((200 - 150 + 1) * Rnd + 150)
would return a random number between 150 and 200
Int ((999 - 100 + 1) * Rnd + 100)
would return a random number between 100 and 999