Find Blank Date Fields?

  • Thread starter Thread starter Randy
  • Start date Start date
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.
 
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.
 
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]
 
Back
Top