averaging the cost of a subform to a main form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank You - That was perfect

Ofer said:
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

zeniae said:
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
Click to expand...
Click to expand...
 
Back
Top