We have a WINNER!! Thanks very much. That works as expected, the only slight problem it may cause is for example: If I select 8no 3's, 1no 2's and 3no 1's. The calculation has added them all up to get 29 then divided by 12 to get 2.4 and so doesn't round up. However when you look at the sheet there ...

I've just taken all the radio buttons out of the sub forms and the formula just works as it did without the round up function added. Any ideas?

I've just changed the forumla to quickly include only 3 of the radio button values and have divided by 3 instead of the usual 12. I've then take the radio forms out of the sub-form to match the RBQ1 setup. This does something different but it's even more random in the way it rounds up. I've selected...

I've customised each radio button to have a value of 1-6. I've gone through the menu's and cannot see anything that says 'null value' anywhere. The default value on them all is 1 unless the user selects another value. A screen shot of the form is below if that helps at all.Regards

Hi Magus,Thanks for your reply. I've just tried that but it's the same as it was before. I have to click on 9no 2's before it changes the average score from 1 to 2. I would expect the average score to change from 1 to 2 on the 7th questions as at that point there are 7 questions with a score of 2 an...

I've used ES2 to create a user entry form. On that form there are 12 questions and each question has a radio button with a scoring system from 1 to 6 on it. The user is asked to select a score from the radio button for all 12 questions and then at the bottom the form gives an average score. This all...