Display Average as a radio button

[boo]

Hi

I have a form, frm_Feedback, which displays the feedback received for each job done by the related interpreter. The frm_Feedback allows a radio button to be selected, either - Very Dissatisfied, Dissatisfied, Neutral, Satisfied, or Very Satisfied. Each one of these then assigns a value for each job from 1 (Very Dissatisfied) through to 5 (Very Satisfied). Is it possible to display the average for all jobs in the same way, ie showing the 5 radio buttons with the average one selected?



Thanks.

[June7]

This is best done in a report. Conventional axiom for databases is 'enter raw data, do calcs in reports'.

[boo]

Thanks for the reply June7. I understand about carrying out calcs in the reports. I think the above may be possible using VBA, so I will bring the query over to that part of the forum.

[June7]

A GROUP BY query with an Avg calc should produce the aggregation. You can base a form on that query. You don't want to show the detail records that contribute to the aggregate calc?

[boo]

Hi again June7, thanks very much for the reply. I actually figured out a way to do it - I rounded the average feedback value in a non-visible text box, txtAvgFB, using =round(Avg([Feedback])), then changed the control source for my option group containing the radio buttons to =[txtAvgFB]. This gave me the result I was after.

Cheers for taking the time to look at the question.