Crosstab probs

[Basil]

Hiya,

I have a grouped select query generating this:

Ref Key Referral Clinic Inpatient Follow-Up
......................................................
6526 Accepted Accepted Accepted Accepted
9745 Accepted Open
10760 Closed
11932 Accepted Accepted Accepted
.... (etc)

I am trying to make a crosstab as follows (to make a chart
from) (value is count of ref key):

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

But I can't seem to do it as I can't make the content of
multiple fields the column header, nor can I put the field
names as rows. The alternative would be to swap the X and
Y axes so to speak, but I can't do this for similar
reasons.

This is what I have achieved (grouped select query):

Referral Clinic Inpatient Follow-Up CountofRefKey
...........................................................
Accepted Accepted 425
Accepted Accepted Accepted 1260
Accepted Accepted Accepted Accepted 1025
Accepted Closed 1705
Accepted Open 324
Closed 592
Open 116

I tried to do them all seperately, but since the data is
all interlinked, I couldn't get it to work. Does anyone
have any ideas??? I would really appreciate any advice,
including if I'm wasting my time!!

Cheers loads.

Baz