Unbound Textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Frank said:
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.
Click to expand...


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.
 
Back
Top