Crosstab Column Headings

None of the Field Names are showing up as column headings for my crosstab
query.

Here is my SQL:

TRANSFORM Avg(dbo_tblTranCHECK.DISC_PRINT) AS AvgOfDISC_PRINT
SELECT dbo_tblTranCHECK.UNITNUM
FROM dbo_tblNameDSC INNER JOIN dbo_tblTranCHECK ON (dbo_tblNameDSC.CODE =
dbo_tblTranCHECK.DISC_TYPE) AND (dbo_tblNameDSC.UNITNUM =
dbo_tblTranCHECK.UNITNUM)
WHERE (((dbo_tblNameDSC.CODE)0) AND
((dbo_tblTranCHECK.SALESDATE)=#6/27/2008# And
(dbo_tblTranCHECK.SALESDATE)=#7/31/2008#))
GROUP BY dbo_tblTranCHECK.UNITNUM
PIVOT dbo_tblNameDSC.NAME;

All Fields show up, but the heading for each one is "Avg Comp".

I've tried listing the Field Names using the IN[] statement, but the same
thing happens. It will list the different categories, but the heading still
shows up as "Avg Comp".

Please help!

Post some sample data from the tables.
--
KARL DEWEY
Build a little - Test a little


"Movies Man" wrote:

None of the Field Names are showing up as column headings for my crosstab
query.

Here is my SQL:

TRANSFORM Avg(dbo_tblTranCHECK.DISC_PRINT) AS AvgOfDISC_PRINT
SELECT dbo_tblTranCHECK.UNITNUM
FROM dbo_tblNameDSC INNER JOIN dbo_tblTranCHECK ON (dbo_tblNameDSC.CODE =
dbo_tblTranCHECK.DISC_TYPE) AND (dbo_tblNameDSC.UNITNUM =
dbo_tblTranCHECK.UNITNUM)
WHERE (((dbo_tblNameDSC.CODE)0) AND
((dbo_tblTranCHECK.SALESDATE)=#6/27/2008# And
(dbo_tblTranCHECK.SALESDATE)=#7/31/2008#))
GROUP BY dbo_tblTranCHECK.UNITNUM
PIVOT dbo_tblNameDSC.NAME;

All Fields show up, but the heading for each one is "Avg Comp".

I've tried listing the Field Names using the IN[] statement, but the same
thing happens. It will list the different categories, but the heading still
shows up as "Avg Comp".

Please help!