combo box values to be assigned percentage while reporting

[jj1]

I have a combo box in which I have options "Highly satisfied", "Satisfied", "Not satisfied". What my company wants to do is see employee satisfaction after 10 meetings with the company. They want me to convert while reporting "Highly satisfied" to 100% satisfied to 75% and not satisfied to 50%. so the report should show. Meeting 1 employee 1 was 100% satisfied. meeting2 50% and meeting3 75% and then calculate average satisfaction of that employees in three meetings so average 100% +50%+75%. How can I do that. How can I assign % to the combo box values?

[ranman256]

in the combo box control source...
if it uses a table, add the column Pct and give it the value.
or If you use VALUES, set the 2nd value to the percentage....HIGHLY;100;SATISFIED;70
ALSO set the columns = 2