|
Arithmetic Operators |
|||
|
Operator |
Description |
Example |
Limits Records To |
|
+ |
Addition |
=Cost+50 |
Values equal to 50 or more than the value in the Cost field |
|
- |
Subtraction |
=Cost-50 |
Values equal to 50 or less than the value in the Cost field |
|
* |
Multiplication |
=Cost*50 |
Values twice the amount in the Cost field |
|
/ |
Division |
=Cost/2 |
Values half the amount in the Cost field |
|
\ |
Integer division |
=Cost\2 |
The integer portion of values that result from dividing the cost field by 2 |
|
Mod |
Modulo division |
=Cost Mod 2 |
The remainder of dividing the Cost value by 2 |
|
Comparison Operators |
|||
|
Operator |
Description |
Example |
Limits Records to |
|
= |
Equals |
=Books or =”Books” |
Text value Books |
|
> |
Greater Than |
>7/15/98 or >#7/15/98# |
Dates later than July 15, 1998 |
|
< |
Less Than |
<1500 |
Values less than 1500 |
|
>= |
Greater than or equal to |
>=15 |
Values greater than or equal to 15 |
|
<= |
Less than or equal to |
<=1/1/00 or <=#1/1/00# |
Dates on or before January 1, 2000 |
|
<> |
Not equal to |
<>NY or <>”NY” |
Values other than NY |
|
Operators used in Expression |
|||
|
Operator |
Description |
Example |
Limits Records to |
|
Between…And |
Between two values, inclusive |
Between 100 and 500 |
Numbers from 100 and 500, inclusive |
|
In |
Included in a set of values |
In (“Germany”, “France”) |
Either Germany of France |
|
Is Null |
Field is empty |
Is Null |
Records with no value in the field |
|
Is Not Null |
Field is not empty |
Is Not Null |
Record with a value in the field |
|
‘’’’ |
Field contains a zero-length string |
=’’’’ |
Records with a zer0-length string in the field |
|
Like |
With wildcards, matched a patter |
Like “C*” or Like “C” |
Any text values the begin with C |
|
Logical Operators |
|||
|
Operator |
Description |
Example |
Limits Records to |
|
And |
Both conditions are True |
>=10 And <=100 |
Values are between 10 and 100, inclusive |
|
Or |
Either conditions is true |
Books Or Videos or “Books” Or “Videos” |
Either Books and Videos |
|
Not |
Not True |
Not Like AB* or Not Like “AB” |
All values except those beginning with AB |
|
Using the Date in Functions |
|||
|
Operator |
Description |
Example |
Limits Records to |
|
Date () |
<Date()+45 |
|
Displays a date that is 45 from today’s date |
|
DateAdd() |
>DateAdd (“m”, 6, Date()) |
|
Displays a date that is more than 6 months from today. The m isolates the month value |