Preventing null records in report

[LHWC]

I have a report that uses a single table as its record source. It uses six fields out of 80 or so in the table. Some records have null values in one or more fields. How can I prevent a record from showing in the report if it has a null value in a particular field?
Thanks in advance...

 

[RoyVidar]

Use a query based on that table as recordsource of the report. In the criteria row of the field(s) where you whish to avoid nulls, type

[tt]not is null[/tt]

Roy-Vidar