Column header

[hermie]

In my crosstab query I put the column header as follow:
Gender: ([femenino] & [masculino]) This shows the result as I want to have
it wiyh Column header 0-1 and -10. Now when I change the Criteria of the
Column header in "Femenino","Masculino" then my data get lost?
SQL before the change of column header is:
TRANSFORM Count(temp1.ss) AS CountOfss
SELECT temp1.group, Count(temp1.ss) AS [Total Of ss]
FROM temp1
GROUP BY temp1.group
PIVOT ([femenino] & [masculino]);

The SQL after I put the column heading is:
TRANSFORM Count(temp1.ss) AS CountOfss
SELECT temp1.group, Count(temp1.ss) AS [Total Of ss]
FROM temp1
GROUP BY temp1.group
PIVOT ([femenino] & [masculino]) In ("Femenino","Masculino");

How to put the column header with Femenino and Masculino without loosing may
data?

Hermie

 

[hermie]

I forgot to show an example
Now it is:
group TotalofSS 0-1 -10
a 23 9 14
b 63 29 34

Like to see:
group TotalofSS Femenino Masculino
a 23 9 14
b 63 29 34

hermie