averaging the cost of a subform to a main form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zeniae - 14 Apr 2005 21:29 GMT

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

Reply to this Message

Ofer - 14 Apr 2005 22:54 GMT

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

Reply to this Message

esparzaone - 14 Apr 2005 23:43 GMT

Thank You - That was perfect

> create a field on your sub form at the form footer that avarage the field
> price.
[quoted text clipped - 11 lines]
> > averages the unit price from my subform? Somewhat new any info would help!
> > Thanks

Reply to this Message