Hi i have a textbox on continous form showing the percentage. I used =Avg([txtAvgPer]) to display the average in another textbox, however its showing '#Name'. Any help will be much appricated. Thank you.
Printable View
Hi i have a textbox on continous form showing the percentage. I used =Avg([txtAvgPer]) to display the average in another textbox, however its showing '#Name'. Any help will be much appricated. Thank you.
I don't think you can AVG() a text value. You also need at least 2 numbers to get an average. Don't know if the continous form affects it.