i just realized that the Avg function cannot "average" the values of elements on a report...(that is, if I have a textbox named "Joe" bound to a field named "Jane", if I set a textbox at the footer to have a value = Avg([Jane])
an error would occur)
kinda sounds funky but... there it is
anyway, i've had to setup a query object to facilitate my task, so that the query's filter would depend on the user determined values on the calling form...
I think the problem you are running into is a naming issue on the report. When you add fields from the Field List to your report, the name of the textbox control is the name of the field (ex. Field1). Then when you make the field calculated using Sum or in your case, Avg, the source becomes =Avg(Field1). When Access tries to calculate the average it does not know if you are talking about the Field1 field or the Field1 textbox. I will rename the textbox to something like txtField1. Then the error should go away.
i did try out playing with the names, but similarly, error did display
i think i'm stuck with using davg for reports
anyway, the reason i so wanted to use the avg function was so that
the reports resulting averages would dpend on the calling form's filter
unlike when they just have the same query,
when a filter is applied on the form, it does not automatically reflect on the report