Microsoft KB Archive/46072

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

= 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.