Microsoft KB Archive/64782

Works: Querying for Blank Fields with the OR Operator (|)

PSS ID Number: Q64782 Article last modified on 06-12-1996

2.00

MS-DOS

= SUMMARY =

There are two ways to query for blank fields in the Database: either by entering “==0” or “=~”. If either of these queries is used with the logical operator OR (|) to link multiple conditions (create a compound query) in a single field, Microsoft Works version 2.00 will sometimes ignore the query, depending on where and how the query is entered.

For a compound query to contain a condition that queries for a blank field, the query must actually be entered into the field that will contain blank records.

For example, with the following information in the Database

Field1 Field2 —— ——

John aaa Mary Susan ccc

enter the following query in View Query (press ALT, V, Q):

Field2: ==0|Field1=“John”

-or-

Field2: ==~|Field1=“John”

This returns all records where Field2 is blank and Field1 is John.

The queries below do NOT return the correct information:

Field1: ==“John”|Field2==0

Field1: ==“John”|Field2=~

Reference(s):

“Microsoft Works Reference.” Version 2.00, Pages 225-226.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words:

=
================================================================ Copyright Microsoft Corporation 1996.