Show AllComparison operators are used in expressions that are used as criteria to select records and limit a result set.
Comparison operator |
Meaning |
Example |
In the Criteria Field, click |
In the Value box, type |
|---|---|---|---|---|
| = (equal sign) | Equal to | Finds records for customers in Germany | Country | =Germany |
| <> (not equal to sign) | Not equal to | Finds records for suppliers outside the United States | Country | <>USA |
| > (greater than sign) | Greater than | Finds records for orders placed after a specific date | Order_Date | >6/30/2000 |
| < (less than sign) | Less than | Finds records for orders placed before a specific date | Order_Date | <6/30/2000 |
| >= (greater than or equal to sign) | Greater than or equal to | Finds records for orders placed on or after a specific date | Order_Date | >=6/30/2000 |
| <= (less than or equal to sign) | Less than or equal to | Finds records for orders placed on or before a specific date | Order_Date | <=6/30/2000 |