ID: Q122505
The information in this article applies to:
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.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
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