Unbound Textbox on a Report

[cornishteeth]

One last question and I should be done. I have an unbound textbox on a report with a control source =Avg([FOOTAGE]). If there is a null value in FOOTAGE, I normally enter a <>0 under criteria if I was working with a query. Unfortunately, I am working with a report and I think there is no criteria area. Where would I need to do this in a report to allow Null values to not be entered into the formula.

Cheers,

Cornish Teeth

 

[bat17]

From memory, the Average function ignores Nulls it does not treat them as Zeros.

Peter