Can someone help with criteria? Greater than dollar amount?

  • Thread starter Thread starter Doog81
  • Start date Start date
D

Doog81

Just started using access for a class. Don't know how to select criteria
greater than a certain dollar amount. Need help.
 
Build a query that includes the table column for the dollar amount. In the
query column that shows the dollar amount, go to the Criteria box and enter:
[Greater Than How Much?]
Click to expand...

The query will prompt for the value, or if the value is always the same just
use it:
1100.50
Click to expand...

Make sure you leave out any $ signs or commas.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
users must enter value = or > than a certain value 3
Form question 3
Count if two arguments are true 2
Forms question 3
How do I roundup to 2 places left of the decimal point? 9
Sumif comparing dates in criteria 1
Rounding numbers when writing a Check 1

Back
Top