Microsoft KB Archive/196716

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

Article ID: 196716

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Word 97 Standard Edition

-



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:

is Blank            (empty) Or              Equal to             (text) Or              is Not Blank         (empty) Or              Not Equal to         (text) Or              Less than            (text) and you modify the entry by selecting (none) from the Field list, your query changes to this:                    is Blank             (text) Or              is Blank             (empty) Or              is Blank             (text) Or              is Blank             (text) Your query should change to this:                    Equal to             (text) Or              is Not Blank         (empty) Or              Not Equal to         (text) Or              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: kbbug kbmerge kbpending KB196716

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.