Thank you, that was perfect !
Only thing was.. My groups had values from 0-5 not 1-6, but that was easy to change.
If all the sections are a Zero value.. How do I get the answer to show a Zero?
currently when its equal to zero.. it shows a blank answer in the box.
By default the numeric field will show a blank to represent a zero .....allthough if you asked for the rawvalue it woudl report zero. You can define how you want the 0 value to be shown. On teh field click on the Object palette and choose the Patterns button. This will start another dialog. Click the Show zero and then in the field below indicate how you want to display your zero. In my case I put a 0 but you coudl put empty or anything you want. See the screen shot below: