Problem with AVE on form

[scottmvinovrski]

I am trying to calculate ave in a textbox coming from my form, "Scores 1 and Scores 2." I am using in the control source the following: AVE([Scores1]+[Scores 2], but an getting an error #Name. I am very new to creating formulas and such in access and any help is appreciated. I have used a similar formula for SUM: SUM([Scores1]+[Scores 2], and havent had any problems with it calculating. Thanks for any help.

 

[boblarson]

Are you using AVE or AVG (AVG is the correct one to use). There isn't an AVE function.

 

[scottmvinovrski]

Thanks for the feedback i was using AVE. I am trying to calculate the average for just that justified form and not my entire database. Any suggestions on how i can make that happen?