Trying to find an empty date field

[Afrosheen via AccessMonster.com]

Thanks for reading this. The code may be wrong. Here's my code:

strWhere = "tblTaps.WorkRec=isnull" & _
" and tbltaps.WorkPlan=""" & Me.Combo149 & _
""" and tblTaps.archive=false" & _
" AND tblMain.Supervisor=""" & Me.cboloc & """"

I'm trying to have it where it check to see if WorkRec [date field] is empty.
The rest of the code seems to be working. When I do a debug.print this is
what it gives me.

tblTaps.WorkRec=null and tbltaps.WorkPlan="January" and tblTaps.archive=false
AND tblMain.Supervisor="BOYKIN, DENNIS".

I know in the query there are no date fields filled in so it should show
something I would think.

Thanks

 

[bhicks11 via AccessMonster.com]

where(((tblTaps.WorkRec) is null))

Bonnie
http://www.dataplus-svc.com

Thanks for reading this. The code may be wrong. Here's my code:

strWhere = "tblTaps.WorkRec=isnull" & _
" and tbltaps.WorkPlan=""" & Me.Combo149 & _
""" and tblTaps.archive=false" & _
" AND tblMain.Supervisor=""" & Me.cboloc & """"

I'm trying to have it where it check to see if WorkRec [date field] is empty.
The rest of the code seems to be working. When I do a debug.print this is
what it gives me.

tblTaps.WorkRec=null and tbltaps.WorkPlan="January" and tblTaps.archive=false
AND tblMain.Supervisor="BOYKIN, DENNIS".

I know in the query there are no date fields filled in so it should show
something I would think.

Thanks

 

[Afrosheen via AccessMonster.com]

Thanks for your quick reply. I really appreciate it. It works great.

where(((tblTaps.WorkRec) is null))

Bonnie
http://www.dataplus-svc.com

Thanks for reading this. The code may be wrong. Here's my code:

[quoted text clipped - 14 lines]

Thanks

 

[bhicks11 via AccessMonster.com]

Good, good!

Thanks for your quick reply. I really appreciate it. It works great.

where(((tblTaps.WorkRec) is null))

[quoted text clipped - 6 lines]