Code to Filter by Null

[lovett10]

I have some code. I want it to filter the Total Hours Worked column by Null.(show only the fields that hae nothing in tat column)

Here is my code

    ElseIf Me.chkIncompleted = True Then
         strFilter = "[Total Travel Time] = Is Null"
            Debug.Print strFilter
                    DoCmd.Close
        DoCmd.OpenReport "VisitSheetTableReport", acViewReport, , strFilter

the error i get is:
Run-time error '3075':

Syntax error (missing operator_ in query expression '[Total Travel Time] = Is Null'.

Thanks for any help in advance

 

[Addyman]

Should it not just be = Null rather than = Is Null

 

[vbaInet]

It should be:

strFilter = "[Total Travel Time] Is Null"

No equal to sign.