If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Crosstab Column Headings
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! |
Thread Tools | |
Display Modes | |
|
|