Avg function?

[DJKAOS]

I have a access form with a edit box that contains a huge complicated formula, this works fine. (call it &quot;MyEditBox&quot<br><br>Now I want another edit box to display the average of all of these, but I get #Name? error.<br><br>I used this as my formula<br><br>=Avg([MyEditBox])<br><br>and it doesnt work.&nbsp;&nbsp;I think it works if I try to average something directly from the table variables, but not from a form.<br><br>Any ideas?<br><br>thanks<br>

 

[WaltLukeIII]

try = avg(me![MyEditBox])<br>I think it is looking for a field MyEditBox from the control source this should look directly at the table. <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[MichaelRed]

Avg (in MS Access and MOST data base apps (those which adhere to SQL standards) is an SQL keyword.&nbsp;&nbsp;It _ONLY_ 'works' within an SQL (e.g. Query) statement.

 

[DJKAOS]

I tried that me![MyEditBox]&nbsp;&nbsp;<br>and it didn't work.<br><br>I also tried to use Avg on a querry, and it didn't work.&nbsp;&nbsp;I don't know whats going on now I can't make it average anything no matter what I do.&nbsp;&nbsp;I had it working before but it was averaging something I didn't wan't averaged.&nbsp;&nbsp;Now that wont even work.

 

[WaltLukeIII]

Do you store the answer to your lond formula anywhere?<br> <p>Walt III<br><a href=mailto:SAElukewl@netscape.net>SAElukewl@netscape.net</a><br><a href=

http://www.muc.edu/~lukewl>homepage</a><br>

 

[Guest_imported]

Please post the formula you are using in the text box.