WD97: Selecting "(None)" Resets Filter Comparison (196716)


The information in this article applies to:

  • Microsoft Word 97 for Windows
This article was previously published under Q196716

SYMPTOMS

In the Query Options dialog box, if you delete a query that precedes another query, the comparison criteria for all subsequent queries change to match that of the query that was deleted.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

For example, if your query options are set up as follows 
             Field:          Comparison:          Compare to:

             <field1>        is Blank             (empty)
   Or        <field2>        Equal to             (text)
   Or        <field3>        is Not Blank         (empty)
   Or        <field4>        Not Equal to         (text)
   Or        <field5>        Less than            (text)
and you modify the <field1> entry by selecting (none) from the Field list, your query changes to this: 
             <field2>        is Blank             (text)
   Or        <field3>        is Blank             (empty)
   Or        <field4>        is Blank             (text)
   Or        <field5>        is Blank             (text)
Your query should change to this: 
             <field2>        Equal to             (text)
   Or        <field3>        is Not Blank         (empty)
   Or        <field4>        Not Equal to         (text)
   Or        <field5>        Less than            (text)
You can find these query options on the Filter Records tab. To locate this tab, follow these steps:
  1. Open the mail merge main document.
  2. On the Tools menu, click Mail Merge.
  3. Under "Merge the data with the document", click Query Options.
Modification Type:MajorLast Reviewed:11/14/2000
Keywords:kbbug kbmerge KB196716
©2002 Microsoft Corporation. All rights reserved.