Traffic Light RAG rating

[Garryw]

Hi,

I would like to set up a report showing traffic light RAG rating for data in my table.

I have a field within each record that contains the numbers 1, 2, 3, and 4.

I would like to produce a query/report which counts the number of records showing 1's and 2s and displays the result as a percentage of the total number of records, and displays the result as a green traffic light.

I then want to count up the number of records showing the number 3 and show that result as a percentage of the total number of records, and displays the result as an amber traffic light

Then I want to do the same with the records showing the number 4 in the same way, but with a red traffic light.

I would preferably like the red, amber, green with the percentages to the right.

Hope this makes sense?

Regards

Garry