averaging the cost of a subform to a main form

[zeniae]

what I am trying to do is get an average price for a product. I have set up
a form called products which tells me the units on hand/ units on order etc.
my subform to this shows me date/po/#order/#recieved/Unit price. What I want
to do is on my main form I want a text box that says average price that
averages the unit price from my subform? Somewhat new any info would help!
Thanks

 

[Ofer]

create a field on your sub form at the form footer that avarage the field
price.
on the cntrol source of that field write "=avg([price])""
make it not visible

Now create another field on your form, and link it to the field you created
at the sub form.
"="MySubName.Form!AvgFieldName

 

[esparzaone]

Thank You - That was perfect

create a field on your sub form at the form footer that avarage the field
price.
on the cntrol source of that field write "=avg([price])""
make it not visible

Now create another field on your form, and link it to the field you created
at the sub form.
"="MySubName.Form!AvgFieldName

what I am trying to do is get an average price for a product. I have set up
a form called products which tells me the units on hand/ units on order etc.
my subform to this shows me date/po/#order/#recieved/Unit price. What I want
to do is on my main form I want a text box that says average price that
averages the unit price from my subform? Somewhat new any info would help!
Thanks