Crosstab Worries

[Jeremy Noland]

Here is what my crosstab sets out currently:

Country MSPH-M MPH-M MPH-F MSPH-F Course-M ...
Bangledesh 2 1 1 0 8
China 0 3 2 1 4
India 6 1 0 0 3

The trailing M's and F's are for male and female,
respectively. What I want to do is be able to combine
some of the column headings while retaining the sum:

Example:

Country MS/MPH-M MS/MPH-F Short-Term-M...
Bangledesh 3 1 13
China 3 3 5
India 7 0 6

Can anyone point me in the direction of doing so...I
believe I am going to need to keep the crosstab I have
and create a Simple Query to combine (but the sum
function doesn't work as I expect across the multiple
fields in SQL).

Thanks,
Jeremy