Avg in Reports

[LEE hepworth]

At the moment I have a report that works out a calculation if if there is a 0 as below

=IIf([Ele Weekly]=0,0,([SumOfEle Verbal])/[Ele Weekly])

But I also run a aVG on this but if the above statement is 0 it comes with an error..

What I use is this below....

=Avg([SumOfEle Verbal])/[Ele Weekly]


Please Help.......

 

[wizcow2]

Lee

Here is a previous post regaurding agrigate functions.
It might help
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=58068

Tom