Confusing Select Expert Criteria 1

[jodie]

I type this in my Select Expert in parentheses so it recognizes it is two separate conditions.
(Effective Date in Date(2002,01,01) to Date(2002,12,31) and Status = "Committed&quot and
(Effective Date in Date(2002,01,01) to Date(2003,01,06)and Status = "Sold&quot


However, when I hit Accept, the Select Expert shows:
Effective Date in Date(2002,01,01) to Date(2002,12,31) and
Effective Date in Date(2002,01,01) to Date(2003,01,06)and
Status = "Sold" and
Status = "Committed"

and so my report shows no data.

If tried parentheses around the 2 criteria...however am I missing something. Why doesn't the report recognize the criteria the way I want it to.

Thanks

 

[GJParker]

Try OR instead of and

(Effective Date in Date(2002,01,01) to Date(2002,12,31) and Status = "Committed&quot OR(Effective Date in Date(2002,01,01) to Date(2003,01,06)and Status = "Sold&quot
Gary Parker
Systems Support Analyst

 

[chelseatech]

Use Record Selection Formula rather than the select expert.

The OR clause makes this formula too complicated for the Select Expert, while the formula edit can easily do exactly what you want. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm