Filter for blank fields only

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

Guest

Hello,

How can we have a filter that only filter the blank field of date field in
the records. I have 3 date fields. as follows:
Inputby purch input by Oper input by Finance. I see some recored have been
filled out by Purchasing and Finance, but Oper forgot to fill it, so I want
to filther thonse blank date fields and remind them. If possible we can make
it too in Excel.

Thanks

Frank
 
Hello,

How can we have a filter that only filter the blank field of date field in
the records. I have 3 date fields. as follows:
Inputby purch input by Oper input by Finance. I see some recored have been
filled out by Purchasing and Finance, but Oper forgot to fill it, so I want
to filther thonse blank date fields and remind them.
Click to expand...

Use a Query with a criterion of

IS NULL

on this field.
If possible we can make it too in Excel.
Click to expand...

Not sure how you'ld do it in Excel - I'd suggest asking in an Excel newsgroup.

John W. Vinson [MVP]
 
Thank you very much John, it works perfectly for me. As to the excel there is
an option of "blank" in the auto filter windows

Frank
 
Back
Top