Filter report by fields with Null value (1 Viewer)

[lovett10]

Re-read the last sentence in my last post I mentioned two cases.

Neither are the case?

 

[vbaInet]

I've spotted it:

            strFilter = "[Total Hours Worked] Is Null And (" & _
                        "[Engineer 1] = '" & Me!cbrEngineer & "' OR " & _
                        "[Engineer 2] = '" [COLOR=Red]&[/COLOR] Me!cbrEngineer & "' OR " & _
                        "[Engineer 3] = '" & Me!cbrEngineer & "')"

 

[lovett10]

I've spotted it:

            strFilter = "[Total Hours Worked] Is Null And (" & _
                        "[Engineer 1] = '" & Me!cbrEngineer & "' OR " & _
                        "[Engineer 2] = '" [COLOR=red]&[/COLOR] Me!cbrEngineer & "' OR " & _
                        "[Engineer 3] = '" & Me!cbrEngineer & "')"

ahh nice one.... i think its working now but i still think i need to put the ors and and's

 

[lovett10]

ahh nice one.... i think its working now but i still think i need to put the ors and and's

Hmm its still showing the ones where the total hours worked isnt Null

 

[vbaInet]

ahh nice one.... i think its working now but i still think i need to put the ors and and's

No you don't!

 

[lovett10]

Hmm its still showing the ones where the total hours worked isnt Null

ahh nevermind i know why thanks for the help

 

[vbaInet]

Hmm its still showing the ones where the total hours worked isnt Null

Show me a sample db.

 

[lovett10]

oh btw can you do Me.chkIncompleted = NotTrue

????

 

[vbaInet]

ahh nevermind i know why thanks for the help

Why is it? Some other criteria somewhere?

 

[vbaInet]

oh btw can you do Me.chkIncompleted = NotTrue

????

Not Me.chkIncompleted = True

OR

Me.chkIncompleted = False

 

[lovett10]

oh btw can you do Me.chkIncompleted = NotTrue

????

nevermind False seems to cover both untrue states