Find Blank Date Fields?

[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.

 

[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.

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

 

[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.

Almost there:

IS NULL

two words with a blank.

John W. Vinson[MVP]