Fields (Variables) in Report with null values

[Mechele]

How do I keep records with a null value in a field from appearing on my report?

I have created a comment report with 10 text boxes. The text boxes are bound to fields (Comments1, Comments2, etc.) with a data type defined as memo. Currently all records are being display, even those with null values.

 

[lightray]

Hi Mechele, is your reports inport source from a query or straight from the table. In a query you could set a criteria where the record ID (PK) could be tested for Null. It seems odd the you have records with no values, unless you just mean for the fields you are selecting, in which case test one of those fields for a Null value. Hope that helps

 

[Mechele]

Each records has 13 comments fields by department. My report source is a query. I am grouping by department and I only want the comments fields to appear that are not null by department.

 

[lightray]

Then I think you need to drop a second department field into the query. Turn the group by into Where. Then down on the criteria line, Is Not Null
try that.
Edit: Oh and don't have the show box checked.