crystal report select expert

[michelleHEC]

MONTH({EMPDETL.BDAY}) ={?Month} OR
MONTH({EMPDETL.ANNIVERSARY}) ={?Month} OR
MONTH({EMPDETL.HDATE}) ={?Month} and
{EMPDETL.STATUS} = "A"

what could be wrong with this? I still see status items that are not "A"

thank you.

 

[michelleHEC]

ok, the problem was the or was overriding the and statement.
puting parentheses around the or statements corrected it.

(MONTH({EMPDETL.BDAY}) ={?Month} OR
MONTH({EMPDETL.ANNIVERSARY}) ={?Month} OR
MONTH({EMPDETL.HDATE}) ={?Month}) and
{EMPDETL.STATUS} = "A