M
Movies Man
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!
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!