Average column in Subform

[Gary Hull]

I have a main form with a sub form

I want to Average a column on the Sub form and place the answer in a text
box on the Main form

Looking to the best way for this to be done

Thanks

 

[Marshall Barton]

I have a main form with a sub form

I want to Average a column on the Sub form and place the answer in a text
box on the Main form

Place a text box named txtAvgXXX in the subform's form
footer section. Set its control source expression to
=Avg(XXX)

Then the main form's text box can display the average by
using the expression:
=subformcontrol.Form.txtAvgXXX

Change the XXX to the name of the field in the subreport's
record source table/query.