Query on Date Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
Back
Top