Count number of hits.

Hi all.

I want to show the number of hits of a certain status from a table. The result should be something like this:

Custnr StatusA StatusB StatusC

123456   1         0         0
123457   0         0         0
123458   3         1         0
123459   9         2         2

Can anybody help me with this? Any help would be greatly appreciated :o)

/Kenneth Received on Tue Nov 19 2002 - 13:27:29 CST