Hide results which are null

[vavs]

I am writing a report which groups results by Vendor and Evaluator. I am creating a sum and average of all none null responses. If an evaluator has not yet responded, I don't want to display them at all. I have groups based on Vendor, then evaluator. How do I hide the null values on the report? I do not want to see the label or the blank line.

 

[Norie]

In the underlying query use Is Not Null against the field that might contain Null values.

This will exclude any records where that field is Null.

 

[vavs]

I have not expressed my question well.

Vendor name groups all of the vendor responses. This works fine.
Evaluator name groups all of the evaluators based on the vendor. This also works fine. The only thing I want to do is to not show the evaluator sum and average if there is nothing to show. In other words, give me only sum and average if there is a sum and average that can and was calculated.

I hope this clarifies my question.

 

[paulhorn]

Hi Vavs,
Are the fields calculated on the report itself, or are they fieldsin the underlying query?

If they are part of the query, then Norie's solution will be good.
If they are calculated fields then an IF statement should do the trick - something like; IIf([EvaluatorSum] is null, "",[EvaluatorSum])

HTH