<div>
<div class="content wysiwyg-content">
Experts, I am surprised this is as difficult as it is. I have made a qry with the following as &nbsp;a criteria:<br />
Like [Enter The Amount to Find] &amp;&nbsp;*<br />
<br />
I enter the amount such as 150 (expecting to find an amount such as $150,000,000.00) but it returns nothing. <br />
<br />
what is wrong? &nbsp;thanks
</div>
</div>


Experts, I am surprised this is as difficult as it is. I have made a qry with the following as  a criteria:
Like [Enter The Amount to Find] & *

I enter the amount such as 150 (expecting to find an amount such as $150,000,000.00) but it returns nothing. 

what is wrong?  thanks

Use a query to find a currency amount

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.