Unbound Textbox

[Guest]

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.

 

[Marshall Barton]

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.

The aggregate functions always ignore Null values, so that's
not your issue.

If you don't want the report to see records with a zero
value (very different from Null), then the criteria goes
into the report's record source query.

If that's not what you were asking about, please try to
explain it in more detail so I can wrap my head around your
situation.