Sum in form

[Ptrif]

I have a group of text boxes that you can choose either 1, 2, 3 or N/A. I would like to have a text box that would give the total average but not count any that have N/A chosen. Cant figure it out...any help is appreciated.

Thanks

Paul

 

[PHV]

Take a look at the IIf function.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Bullsandbears123]

I would use the average function. But the value for N/A needs to be NULL. If you use AVG(text1,text2,text3...) the fuction should do the work for you. If I'm correct It should not count any null values. But you can label the null value "N/A"

I hope this helps.