Avg(IIF([Score A] = "NA",Null, Val([Score A]))) +
Avg(IIF([Score B] = "NA",Null, Val([Score B]))) +
Avg(IIF([Score C] = "NA",Null, Val([Score C]))) + ...

I am not sure why you are adding the averages but if that is what you
want to do then this will work.

If you want the average score for A and the average score for B then you
need to do the calculation in separate fields.n



'================================================= ===
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'================================================= ===


Rene Hernandez wrote:
How would i include [Score B], [Score C], etc.

Thanks.