Counting

[deejay_totoro]

Hello,

I have a question concerning counting on a report.

I have one field that contains colours, for example:

fldCOLOUR
Blue
Blue
Red
Orange
Blue
Red

What I would like to do is count each type of colour, for example:

The number of Blue in fldCOLOUR is 3
The number of Red in fldCOLOUR is 2
The number of Orange in fldCOLOUR is 1

How might I do this?

Many thanks!

dj_T.