Why? In some expressions, especially
filters, you may need to use "and," "or," or "not."
These are called Boolean operators. For example, you may want to study
all the women over 45. You would make an expression such as
(Sex = "F") and (Age > 45).
Here's what you do:
Type: Sex = "F"
With the blinking cursor to the right of the second quotation mark, press the and button on the keypad. Notice that parentheses appear around Sex = "F".
Type: Age > 45
Notice that when you type the ">" sign, parentheses appear around Age > 45.
When in doubt, use the keypad to make Boolean expressions. But you can also use the following shortcuts:
For and, make sure the preceding expression has parentheses around it and type the word "and."
For and, type "&." (no quotes). This has the same effect as the keypad button.
For or, make sure the preceding expression has parentheses around it and type the word "or."
For or, under Windows type --O (that's the letter O as in Oscar). On the Macintosh it's --O
For not, type "~" (no quotes; ~ is the tilde key, usually in the upper-left of your keyboard).