The first qualification would be interpreted as:
('Assignee+' = "Michael Davis") OR (( 'Assignee+' = "Gurpreet Savi") AND
('Status*' <= 3))
That explains the result return all entries with Status as they match with
"Michael Davis"
AF
On Tue, May 20, 2008 at 5:27 PM, Kathy Morris <[EMAIL PROTECTED]>
wrote:
> ** 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>.
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
