Average column in Subform

  • Thread starter Thread starter Gary Hull
  • Start date Start date
G

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
 
Gary said:
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
Click to expand...


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.
 
Back
Top