|
::
Introduction
::
Database principles
::
Tables
::
Queries
::
Data security
::
Glossary
::
Resources
::
Student Files
:: Contact
:: Back to Main Site
:: Site
Map
|
Microsoft Access - Class 3 - Part VI
|
>
Back |
Access Comparison Operators
|
Operator
|
Meaning
|
Example
|
| |
|
|
| = |
equal to (optional, default operator) |
="Canada" |
| < |
less than |
<#1/1/99# |
| <= |
less than or equal to |
<=100 |
| > |
greater than |
>"C400" |
| >= |
greater than or equal to |
>=18 |
| <> |
not equal to |
<> "Hall" |
| Between….And… |
between two values (inclusive) |
Between 50 and 325 |
| In () |
in a list of values |
In ("Hall", "Seeger") |
| Like |
matches a pattern that includes wildcards |
Like "706*" |
Print this page
|
