Filter report by fields with Null value

[lovett10]

This is my code so far

ElseIf Me.chkIncompleted = True Then
         strFilter = "[Total Hours Worked] = IsNull"
            DoCmd.Close
        DoCmd.OpenReport "VisitSheetTableReport", acViewReport, , strFilter

What i want to achieve is it to return any records that have "Total Hours Worked" Blank so that the user will know that that record is incompleted

Thanks in advances for the help.

 

[vbaInet]

strFilter = "[Total Hours Worked] [COLOR=Blue]Is Null[/COLOR]"

 

[lovett10]

strFilter = "[Total Hours Worked] [COLOR=blue]Is Null[/COLOR]"

i get Run-time error '3075' with that

 

[vbaInet]

What is runtime error 3075?

 

[lovett10]

What is runtime error 3075?

No idea im afraid

 

[vbaInet]

Neither do I

Tell me the error message.

 

[lovett10]

Neither do I

Tell me the error message.

it says Syntax error (missing operator) in query expression '[Total Hours Worked] = Is Null'.

 

[vbaInet]

Look at my code and compare it to yours. Are they the same?

 

[lovett10]

Look at my code and compare it to yours. Are they the same?

Huh... strange they looked exactly the same but then i copied ures in and now it works... Thanks

 

[vbaInet]

Eye for detail lovett Mine doesn't have the equal to sign (=)

 

[vbaInet]

Eye for detail lovett Mine doesn't have the equal to sign (=) before Is Null.

When you're giving code by one of us on here, the best thing to do is to copy it rather than try to fix yours.

 

[lovett10]

Eye for detail lovett Mine doesn't have the equal to sign (=) before Is Null.

When you're giving code by one of us on here, the best thing to do is to copy it rather than try to fix yours.

Wow i cant believe i didnt see that haha, thanks again mate

 

[vbaInet]

You're welcome!

 

[lovett10]

Sorry to botheryou ain but do you know what the problem with this code is?

 ElseIf Me.chkIncompleted = True And Me.cbrEngineer & "" <> "" Then
         strFilter = "[Total Hours Worked] Is Null" And " & _
                        "[Engineer 1] = '" & Me!cbrEngineer & "'Or " & _
                        "[Total Hours Worked] Is Null" And " &" _
                        "[Engineer 2] = '" & Me!cbrEngineer & "'Or " & _
                        "[Total Hours Worked] Is Null" And " &" _
                        "[Engineer 3] = '" & Me!cbrEngineer & "'"
                DoCmd.Close
        DoCmd.OpenReport "VisitSheetTableReport", acViewReport, , strFilter

i get a syntax error

 

[vbaInet]

Everything is. Start with these two lines:

         strFilter = "[Total Hours Worked] Is Null[COLOR=Red]" And " [/COLOR]& _
                        "[Engineer 1] = '" & Me!cbrEngineer & "[COLOR=Red]'Or "[/COLOR] & _

I've highlighted the places that need fixing. Take a good look.

Also, you still haven't normalised.

 

[lovett10]

Everything is. Start with these two lines:

         strFilter = "[Total Hours Worked] Is Null[COLOR=red]" And " [/COLOR]& _
                        "[Engineer 1] = '" & Me!cbrEngineer & "[COLOR=red]'Or "[/COLOR] & _

I've highlighted the places that need fixing. Take a good look.

Also, you still haven't normalised.

I cant see where its gone wrong... and Normalized?

 

[vbaInet]

You're not being patient and thorough with your investigation. Look again paying attention to spaces and concatenation.

Re normalising, I remember telling you about your Engineer1 to 4 issue. You obviously didn't take that on board.

 

[lovett10]

You're not being patient and thorough with your investigation. Look again paying attention to spaces and concatenation.

Re normalising, I remember telling you about your Engineer1 to 4 issue. You obviously didn't take that on board.

I didnt understand what you meant before and then had to do something else, and the rest of them work so why change it?

 

[vbaInet]

That was just a side note. You can ask about that in a different thread if you want. Lookup the term database normalization.

But back to your OP, have you fixed it?

 

[lovett10]

That was just a side note. You can ask about that in a different thread if you want. Lookup the term database normalization.

But back to your OP, have you fixed it?

No. i cant see what the problem is... sorry