Help with an OpenReport Where Condition

[hehrerh]

Hey! Quick question.

I am trying to display a report with the following conditions:

1. The engineering firm matches a combobox selection
2. [isLeaveOffENgReport] = 1
3. [TaskStatusID] = 1 OR 2

I have come up with this Where Condition but it does not work. What should I change? I think the problem is related to how I addressed the TaskStatusID condition.

="[EngineeringFirmID]=" & Nz([cboEngineerReport],0) & " AND [isLeaveOffEngReport]= 1" & " AND [TaskStatusID]= 1 OR 2"

Thank you!


Howie

[orange]

Do you get an error msg and number?

I don't know your details but you could try (untested)



="[EngineeringFirmID]=" & Nz([cboEngineerReport],0) & " AND [isLeaveOffEngReport]= 1 AND ([TaskStatusID]= 1 OR [TaskStatusID]= 2)"