| Field | Expression | Description |
|---|---|---|
| ShipCity | "London" | Displays orders shipped to London. |
| ShipCity | "London" Or "Hedge End" | Uses the Or operator to display orders shipped to London or Hedge End. |
| ShippedDate | Between #1/5/95# And #1/10/95# | Uses the Between...And operator to display orders shipped no earlier than 5-Jan-95 and no later than 10-Jan-95. |
| ShippedDate | #2/2/95# | Displays orders shipped on 2-Feb-95. |
| ShipCountry | In("Canada", "UK") | Uses the In operator to display orders shipped to Canada or the UK. |
| ShipCountry | Not "USA" | Uses the Not operator to display orders shipped to countries other than the USA. |
| ShipName | Like "S*" | Orders shipped to customers whose name starts with the letter S. |
| CompanyName | >="N" | Displays orders shipped to companies whose name starts with the letters N through Z. |
| OrderID | Right([OrderID], 2)="99" | Uses the Right function to display orders with OrderID values ending in 99. |
| CompanyName | Len([CompanyName]) >Val(30) |
Uses the Len and Val functions to display orders for companies whose name is more than 30 characters long. |