Microsoft KB Archive/144155

= Word Doesn't Give AND Rule Precedence in Query =

Article ID: 144155

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 95 Standard Edition
 * Microsoft Word 95a
 * Microsoft Word 6.0 for Macintosh
 * Microsoft Word 6.01 for Macintosh

-



This article was previously published under Q144155



SYMPTOMS
When you create a query that specifies a combination of rules that contain both AND and OR rules, Word processes the rules sequentially instead of processing the set of rules using AND before the set of rules using OR. The "Microsoft Word User's Guide," version 6.0, incorrectly states the following:

...You can use AND and OR separatly or in combination. In sets of rules that contain both AND and OR, rules connected by AND have precedence over rules connected by OR. This means that the set of rules connected by AND is used to select records before the set of rules connected by OR....

For example, if you create the following query to select all records from the city of Portland AND the state of Oregon OR the city of Salem AND the state of Oregon, your query will incorrectly select records for the city of Salem only. Query                                  Word processes this result -                                  --

State (Is) Equal to Oregon AND City (Is) Equal to Portland        Oregon Portland OR State (Is) Equal to Oregon          Oregon AND City (Is) Equal to Salem           Salem Word should process the query like this: Query                                  Word processes this result -                                  --

State (Is) Equal to Oregon AND City (Is) Equal to Portland        Oregon Portland OR State (Is) Equal to Oregon          Oregon Salem AND City (Is) Equal to Salem           Salem Oregon Portland Oregon



STATUS
Microsoft has confirmed this to be a problem in the version of Microsoft Word listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



WORKAROUND
Re-create the query using the structure in the following table. Query                                  Word processes this result -                                  --

City (Is) Equal to Portland OR City (Is) Equal to Salem            Both Cities From Any State AND State (Is) Equal to Oregon         Both Cities Only From Oregon

