C
cjfazio
I have a form where people enter data on a certain subject and then select a
rating from a combo box (either green, white, yellow or red). The combo
box obtains its values from table with two fields (1) rating and (2) numeric
value. The rating values are the text values shown above, the numeric values
are (1,2,3,4).
I created a query that joins the rating table with the data table. Now I am
trying to create a report that will display the average rating for selection
of records. I can get the report to display the numeric average (i.e. 2.25)
of all the records but have not figured out how that number can be converted
back to the text rating (i.e. white).
Can anyone help me get started.
rating from a combo box (either green, white, yellow or red). The combo
box obtains its values from table with two fields (1) rating and (2) numeric
value. The rating values are the text values shown above, the numeric values
are (1,2,3,4).
I created a query that joins the rating table with the data table. Now I am
trying to create a report that will display the average rating for selection
of records. I can get the report to display the numeric average (i.e. 2.25)
of all the records but have not figured out how that number can be converted
back to the text rating (i.e. white).
Can anyone help me get started.