Examples of expressions that use comparison operators
From Microsoft Query
Examples of expressions that use comparison operators
Comparison 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 |