Hi,
I have a report that is based on a query. On the report footer I have a
txtAvg (=Avg([HDays]) which is a calculated field in the query that is on
the report. This calculated field is based on two date fields (ie number of
days between two dates). If one date isn't entered there is no value.
What I want to do is have the average of HDays calculated excluding all
values that are equal to zero or null.
I know this will be easy but I just can't figure it out.

Thanks for any help I may get.
--
niuginikiwi
Nelson, New Zealand

Avg() ignores nulls, so perhaps you could convert your zeros to nulls before
averaging:
=Avg(IIf([HDays]=0, Null, [HDays]))

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"niuginikiwi" <(E-Mail Removed)> wrote in message
news:0D343BAD-FDD1-4017-9AA9-(E-Mail Removed)...
> Hi,
> I have a report that is based on a query. On the report footer I have a
> txtAvg (=Avg([HDays]) which is a calculated field in the query that is on
> the report. This calculated field is based on two date fields (ie number
> of
> days between two dates). If one date isn't entered there is no value.
> What I want to do is have the average of HDays calculated excluding all
> values that are equal to zero or null.
> I know this will be easy but I just can't figure it out.
>
> Thanks for any help I may get.
> --
> niuginikiwi
> Nelson, New Zealand

Thanks Allen,
That not only worked but clarified my understanding a little about nulls and
zeros.
Once again, thanks so much.
--
niuginikiwi
Nelson, New Zealand