Works: Using the NOT operator in a Query
PSS ID Number: Q46072 Article last modified on 10-16-1998
1.00 1.05 2.00 3.00
MS-DOS
====================================================================== 1.00 1.05 2.00 3.00 MS-DOS kbother
| The information in this article applies to: |
| - Microsoft Works for MS-DOS, versions 1.0, 1.05, 2.0, and 3.0 |
SUMMARY
Rather than seeing all records that match a query, you may want to see all records that don’t match a query. If a criterion is complex, it can be reversed by putting a NOT operator in front of the entire formula.
For example, the following query
=Units*Price>=1000&Date>‘5/15/88’
is the opposite of this query:
=~(Units*Price>=1000&Date>‘5/15/88’)
KBCategory: kbother KBSubcategory: dworkskb:
Additional reference words: 1.00 2.00 3.00
Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.
