display only fields not null or empty?

[mfpoore]

Can I make my report, or a form, display only the fields that are not empty or null?
thanks

 

[Malcy]

Hi
You could try filtering off in the query that you use to support the report. Set the criteria to Not Null and <> 0
Depends how your report is structured and if you just want to filter on one field. If you apply the criteria to lost of fields you may end up getting no results at all.
HTH