<div>
Please explain what you mean by &quot;doesn't work&quot;.
</div>


Please explain what you mean by "doesn't work".

<div>
When I attempt to run it, I receive &nbsp;compile error message: &nbsp;&quot;Compile error in query expression&quot; &nbsp;then it shows whatever the criteria in the query was ex. &nbsp;1: Int((7-2+1)*Rnd()+20)
</div>


When I attempt to run it, I receive  compile error message:  "Compile error in query expression"  then it shows whatever the criteria in the query was ex.  1: Int((7-2+1)*Rnd()+20)

<div>
What was the full SQL statement?
</div>


<div>
After additional testing, it turned out the actual database had an issue that caused formulas to drop the last characters. &nbsp;I created a new database, used the same formula and everything is working again. &nbsp;Thanks for the help
</div>


After additional testing, it turned out the actual database had an issue that caused formulas to drop the last characters.  I created a new database, used the same formula and everything is working again.  Thanks for the help

<div>
<div class="content wysiwyg-content">
I have tried the below but am not getting anywhere. &nbsp;Last week the below formula worked,b ut now it doesn't. &nbsp;Is there a better way to random a formula for a MS Access Query to pull for me a random value?<br />
<br />
<br />
Int ((6 - 1 + 1) * Rnd + 1)<br />
<br />
would return a random number between 1 and 6<br />
<br />
<br />
<br />
Int ((200 - 150 + 1) * Rnd + 150)<br />
<br />
would return a random number between 150 and 200<br />
<br />
<br />
<br />
Int ((999 - 100 + 1) * Rnd + 100)<br />
<br />
would return a random number between 100 and 999<br />

</div>
</div>


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


How do I create a query in MS Access 2007 to select a random Value?

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.