Can someone help with criteria? Greater than dollar amount?

D

Doog81

Just started using access for a class. Don't know how to select criteria
greater than a certain dollar amount. Need help.
 
A

Arvin Meyer [MVP]

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.
 
Top