AVG or DAVG - How do I make it ignore both nulls & zeros?

[donnadee]

I have a field that records rating scales of 1 to 5.

Some surveys aren't completely answered so the number field containing the scores turns up null or has a zero.

How do I get an average all numbers for that field, but ignore those that are null and those with zeros? I'm pretty sure it already ignores nulls, but we have to go back and delete the zeros for it to work.

Thanks for your help in advance.

 

[MichaelRed]

just refer to help. DAvg function has a "criteria" argument which (properly stated) will "do it". The same criteria included (different format / syntax) can yield a recordset with only hte values you want.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over