Problems with Report Filter

[eww]

For some reason the filter button in the ribbon doesn't work right with this report I'm opening. The command for the button is:

DoCmd.OpenReport "rptCompletedSubmittals", acViewReport, , "JobNumber = '" & Forms!frmAllProjects!txtJobNumber & "' AND (ReturnedSubmittalDate Is Not Null OR WaivedApprovals Is Not Null)", acWindowNormal

However it seems to be working fine when I make it:

DoCmd.OpenReport "rptCompletedSubmittals", acViewReport, , "JobNumber = '" & Forms!frmAllProjects!txtJobNumber & "' AND ReturnedSubmittalDate Is Not Null", acWindowNormal

Am I using the parentheses wrong? Or is it the "OR" in there. I need to filter so that it shows if one of those is not null, but not necessarily both.

[weekend00]

you may try to put more parentheses:
DoCmd.OpenReport "rptCompletedSubmittals", acViewReport, , "JobNumber = '" & Forms!frmAllProjects!txtJobNumber & "' AND ((ReturnedSubmittalDate Is Not Null ) OR (WaivedApprovals Is Not Null))", acWindowNormal