<div>
Is the form open when you run the query?<br />
<br />
You can test the query - put it into design view and add a column to display the form field. &nbsp;When you run the query, you will see what it is seeing. &nbsp;Are you sure that the data type of the amount field is some numeric data type?
</div>


<div>
My first instinct is that [DollarAmount] is a text field, not numeric. &nbsp;But you might try;<br />
<br />
WHERE [DollarAmount] &gt;&nbsp;val([forms]![frmExcel-Col-<wbr />1]![MinAmo<wbr />unt])
</div>


<div>
Wouldn't that be WHERE Val([DollarAmount]) &gt;&nbsp;[forms]![frmExcel-Col-1]![<wbr />MinAmount]<wbr />) ?<br />
<br />
Of course the problem may be that the form control has a format that is making Access think the form field is a string. &nbsp;In that case, you would use val() on both fields or better still - fix the form control to have a numeric format or no format.
</div>


<div>
Hmm, to my knowledge, control &nbsp;types and queries data types arn't related to each other.<br />
<br />
since with queries the string delimiters are either a single or a double quote, I don't think the fact that the control is a texBox is the problem.<br />
It pretty much looks like the form is closed when the query is run, so the query recieve a null value, and comparing anything with null is always false.
</div>


<div>
Here's the thing... &nbsp;The MAIN database is in SQL Server, and donationAmount is a &quot;money&quot; field. &nbsp;I'm connecting to the database via MS Access, because they all work with Access. &nbsp;So, I'm creating the front end pieces (form, queries, etc.) in Access, which is connecting to the SQL Server database. &nbsp;I probably should have mentioned that earlier ... sorry!
</div>


<div>
<blockquote>
Hmm, to my knowledge, control &nbsp;types and queries data types arn't related to each other.<br />

</blockquote>
They do. &nbsp;For example, Access will recognize an unbound control as a date data type if you format it as a date.<br />
<br />
What data type does Access show as the type for &quot;money&quot;? &nbsp;Do you see Currency or Short Text?
</div>


<div>
Specify the control as a <i>parameter </i>to free Access from guessing what kind of data to expect:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42718917-1"><span>PARAMETERS [Forms]![frmExcel-Col-1]![MinAmount] Currency;</span>
<span>SELECT .. &lt;your current query&gt;</span>
</code></pre>
</div>


<div>
what SQL Server driver are you using for your connection to SQL Server
</div>


<div>
<i>donationAmount</i> is a currency field in Access, and a <i>money</i> field in SQL Server. &nbsp;I've already tried making the unbound text box currency format. &nbsp;That didn't work either.
</div>


<div>
I'm using SQL Server Native Client 11.0 to connect Access to the SQL Server database.
</div>


<div>
Ugh .... so weird! &nbsp;I originally formatted the unbound text box as a general number and I SWEAR it didn't work as query criteria. &nbsp;This morning, it's working. &nbsp;So, I guess this was the answer all along: &nbsp;&gt; [forms]![frmExcel-Col-1]![<wbr />MinAmount]<wbr /><br />
<br />
SO WEIRD! &nbsp;Thank you, everybody, for your help and suggestions.
</div>


<div>
Mark your own comment as the solution.
</div>


<div>
Even though it wasn't really a solution? &nbsp;:)
</div>


<div>
It that what made it work, it was the cure. In this special case.
</div>


<div>
<div class="content wysiwyg-content">
I am building a query in Microsoft Access that is getting it's criteria from a form. &nbsp;I want it to show all donations where the dollar amount is greater than the number entered into the form field. &nbsp;The unbound form field is named <b>MinAmount</b>. &nbsp;In my query, my criteria for the <b>donationAmount </b>field is <b>&gt;[forms]![frmExcel-Col-1]!<wbr />[MinAmount<wbr />]</b>.<br />
<br />
When I run the query, I get no results. &nbsp;When I remove the criteria, it's fine ... I get a ton of results. Yes, there are many donations that are greater than 100, so even with the criteria in place, I should get results. &nbsp;I've tried making the field a general number, currency, etc. &nbsp;Nothing seems to matter. &nbsp;What have I overlooked? &nbsp;Pulling my hair out by now! &nbsp;<br />
<br />
Thank you for any suggestions and help!
</div>
</div>


I am building a query in Microsoft Access that is getting it's criteria from a form.  I want it to show all donations where the dollar amount is greater than the number entered into the form field.  The unbound form field is named MinAmount.  In my query, my criteria for the donationAmount field is >[forms]![frmExcel-Col-1]![MinAmount].

When I run the query, I get no results.  When I remove the criteria, it's fine ... I get a ton of results. Yes, there are many donations that are greater than 100, so even with the criteria in place, I should get results.  I've tried making the field a general number, currency, etc.  Nothing seems to matter.  What have I overlooked?  Pulling my hair out by now!  

Thank you for any suggestions and help!

Criteria in query not working from unbound form value

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.