Find Blank Date Fields?

R

Randy

I need to pull up a report with a date range and all the records that
are blank in Date5 field. I know how to get the date range no problem,
but what is the formular in the criteria to pull up the blank Date5
records? I have tried Null, IsNull, NZ none work.
 
R

RuralGuy

WHERE ((YourTable.DateField) Is Null)

I need to pull up a report with a date range and all the records that
are blank in Date5 field. I know how to get the date range no problem,
but what is the formular in the criteria to pull up the blank Date5
records? I have tried Null, IsNull, NZ none work.
Click to expand...

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
J

John Vinson

I need to pull up a report with a date range and all the records that
are blank in Date5 field. I know how to get the date range no problem,
but what is the formular in the criteria to pull up the blank Date5
records? I have tried Null, IsNull, NZ none work.
Click to expand...

Almost there:

IS NULL

two words with a blank.

John W. Vinson[MVP]
 
Top