WD: Selecting "(None)" Resets Filter Comparison

ID: Q122505

The information in this article applies to:

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.

Additional query words: filter filtering queries same change changes comparison 8.0 8.00

Keywords          : wordnt word8 macword98 winword kbmerge ntword macword word6 word7 word95 
Version           : WINDOWS:6.0,6.0a,6.0c7.0,7.0a;MACINTOSH:6.0,6.0.1,6.0.1a,98
Platform          : MACINTOSH WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: December 5, 1998