Microsoft KB Archive/46072: Difference between revisions
m (Text replacement - ">" to ">") |
m (Text replacement - "&" to "&") |
||
| Line 21: | Line 21: | ||
For example, the following query | For example, the following query | ||
=Units*Price>=1000& | =Units*Price>=1000&Date>‘5/15/88’ | ||
is the opposite of this query: | is the opposite of this query: | ||
=~(Units*Price>=1000& | =~(Units*Price>=1000&Date>‘5/15/88’) | ||
KBCategory: kbother KBSubcategory: dworkskb: | KBCategory: kbother KBSubcategory: dworkskb: | ||
Revision as of 14:20, 21 July 2020
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.
