It literally reads the qualification as: assigned = x ,regardless of status, OR (assigned = x and status less than 3).
It assumes the "and" and the last qualification before it are paired together. When you added the brackets you specified (this group of qualifications) PLUS this qualification. If they had all been "or", or "and", it wouldn't have been a problem. Hope that helps. -----Original Message----- From: Kathy Morris <[EMAIL PROTECTED]> Sent: Tuesday, May 20, 2008 7:26 PM To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> Subject: Qualification Error - Strange? Hello all, I ran this qualification: 'Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi" AND 'Status*' <= 3 Result: status values that such as Closed and Cancelled appeared that have a value of 5 and 6?? When I modified the qualification: ('Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi") AND 'Status*' <= 3 Result: the values that were less than or equal to 3 appeared correctly. What logic is this based on? Sometimes when I use LIKE %Mary Smith I find the name faster than if I type = "Mary Smith" - never understood why. **************Wondering what's for Dinner Tonight? Get new twists on family favorites at AOL Food. (http://food.aol.com/dinner-tonight?NCID=aolfod00030000000001) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" This message is subject to and does not create or vary any contractual relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries or affiliates and you. Internet communications are not secure and therefore the TuringSMI Group does not accept any legal responsibility for the contents of this message. Any views or opinions expressed are those of the author. This message is intended for the addressee(s) only and its contents and any attached files are strictly confidential. If you have received it in error, please contact the sender on the number above. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"