Average box in form

[FpwL1399]

Hi, I would like to put a text box in my form to calculate an average
of the nine boxes before it. I don't really want to do this in a query
because I want the operator to be able to see it immediately. Is there
any Avg() function like in access? Thanks.

 

[Guest]

The only average function available is the DAvg() which applies to a domain.
You will have to do the math yourself. You can put something like this in
the Control Source property of the text box where you want to see the average:
=(Val([text0])+Val([text2])+Val([text4])+Val([text6]))/4

I just set up 4 text boxes for my testing.

 

[FpwL1399]

Thanks much. It worked out like a charm.

The only average function available is the DAvg() which applies to a domain.
You will have to do the math yourself. You can put something like this in
the Control Source property of the text box where you want to see the average:
=(Val([text0])+Val([text2])+Val([text4])+Val([text6]))/4

I just set up 4 text boxes for my testing.

Hi, I would like to put a text box in my form to calculate an average
of the nine boxes before it. I don't really want to do this in a query
because I want the operator to be able to see it immediately. Is there
any Avg() function like in access? Thanks.