using vb.net 2003

I have an multiple column access table, and in one date column (DateIN)configured as data/time shortdate.
I have a data set and data adopter
I need to write a select command which checks if that column has no data in a row pick the other elements of that row
"Select * from tableCheckedout where BookID='" & txtBookid.text & "' AND dateDue < ' # " & mydate & " # ' and DateIN = Blank (no data)"

Can some one help me


yvk

__________________
yvk

"Select * from tableCheckedout where BookID='" & txtBookid.text & "' AND dateDue < ' # " & mydate & " # ' and DateIN IS NULL"

Cheers,
Prabodh