Invisible Nulls

[MTH]

Is there a way to make a null value invisible on a report?

When I Sort my data I want all correspinbding records on one line, but the null values are covering up some good data.

 

[Ally]

In the query that feeds the report, try putting Not IsNull in the criteria line in the column of the field(s) that contain the Null data. If you have got more than one field you'll need to put the Not IsNull on the next line down so that the query sees it as "Or" and not "And".

 

[IgorB]

Try to use function IIF. See examples in Help file.