Crosstab probs

[Basil]

Hiya, this thing never seems to show up on screen -
annoying!

Anyway, this is my problem..

I generate a grouped select query as follows:

refkey referral clinic admitted follow-up
.... .. ..... ...... .... ...... ...... ..... ... ..... ..
6526 accepted accepted
9745 accepted accepted accepted accepted
10760 accepted closed
10764 accepted accepted accepted
10786 accepted open
etc...

What I need from this is:

Type Accepted Closed Open
......... ...... .... ....... ... . ..
Referral 4739 592 116
Clinic 2710 1705 324
Admitted 2285
Follow-Up 1025

This is needed for a chart, but I can't seem to do it.
Could be the other way round (swap x and y axes so to
speak).

Any ideas?? This is what I have managed so far (group
select query):

Referral Clinic Admitted Follow-Up CountofRefkey
..... . . . . ... . . . . . . ... . . . . . . . . . . ...
Accepted Accepted 425
Accepted Accepted Accepted 1257
Accepted Accepted Accepted Accepted 1028
Accepted Closed 1725
Accepted Open 304
Closed 592
Open 116

This isn't suitable for my graph. Any help would really be
appreciated, including if I am wasting my time.

Thanks loads,

Basil