How do I go about adding an average field in report footer that will give me the average of all the scores.

Thanks.

jwood29

Make sure that the control name is not the same as the field name up in the details section and then put a text box in the footer with

=Avg([YourFieldNameHere])

You might need the NZ function if you want to count null fields in.

=Avg(Nz([YourFieldNameHere],0))

boblarsen to the rescue again. Thanks, that's what I needed. Got it calculating nicely now. you still 'da man'.
Good Day bud.

How would I not include 0 "zeros" in the calculation of average?

Thanks.

Use Bob's second example:
=Avg(Nz([YourFieldNameHere],0))