Query on Date Fields

T

T. Fox

What I'd like to do is have a query which, among other things, only shows me a blank field in the table, i.e., where the field name is Date Typed, I only want to see records where there is nothing entered in that field. Through Help, I determined how to request null results by it only works for a text field and my field is a date field. Can anyone guide me through this

Tami
 
M

Michel Walsh

Hi,


SELECT *
FROM somewhere
WHERE myDateTimeField IS NULL



Hoping it may help,
Vanderghast, Access MVP

T. Fox said:
What I'd like to do is have a query which, among other things, only shows
Click to expand...
me a blank field in the table, i.e., where the field name is Date Typed, I
only want to see records where there is nothing entered in that field.
Through Help, I determined how to request null results by it only works for
a text field and my field is a date field. Can anyone guide me through
this?
 
Top