Trouble with record selection formula 1

[utahjzz98]

I am really new to Crystal so this may be an easy question but I am having trouble with a record selection formula. Everthing works fine except where I attempt to narrow 'LOOKUP2' down by 'Help Desk'. It continues to return other records including blank ones. When I have removed the OR operator and only used one 'username' for the 'clsdby' field then the results come back correct but I need the results for both 'usernames'. My code is below, any suggestions would be welcome.

{TASKS.CLSDDATE} in DateTime (2007, 04, 02, 22, 23, 43) to DateTime (2007, 09, 28, 22, 28, 06) and
{TASKS.CLSDBY} = "Username1" or {TASKS.CLSDBY} = "Username2" and
{TASKS.LOOKUP2} = "Help Desk"

 

[lbass]

You need to use parens to tell the formula which clauses go together, as in:

TASKS.CLSDDATE} in DateTime (2007, 04, 02, 22, 23, 43) to DateTime (2007, 09, 28, 22, 28, 06) and
(
{TASKS.CLSDBY} = "Username1" or
{TASKS.CLSDBY} = "Username2"
) and
{TASKS.LOOKUP2} = "Help Desk"

...But you could simplify this to:

TASKS.CLSDDATE} in DateTime (2007, 04, 02, 22, 23, 43) to DateTime (2007, 09, 28, 22, 28, 06) and
{TASKS.CLSDBY} in ["Username1","Username2"] and
{TASKS.LOOKUP2} = "Help Desk"

-LB

 

[utahjzz98]

That did it! Thank you.