Null table field will not include in report

[deanvilar]

Hello Gurus, I need your help to validate if a Field in my table is NULL, details of which will not be included in my report.

I attached sample report wherein the data is sorted by EXPIRATION DATE, first rows displayed the data of NULL EXPIRATION DATE FIELD ...

Thank you in advance.

 

[pbaldy]

Base the report on a query with

Is Not Null

in the criteria for that field.

 

[deanvilar]

Thanks for the reply Paul ... I got it!

 

[pbaldy]

Happy to help!