none
Crosstab query question RRS feed

  • Question

  • I have the following crosstab query

    TRANSFORM First(QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.Value) AS [VALUE]
    SELECT QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.SessionNumber AS [SESSION NUMBER], QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.PartNumber AS [PART NUMBER], QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.PartName AS [PART NAME], QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.OP AS OP, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.IPRev AS [IP REV], QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.JobNumber AS [JOB NUMBER], QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.WorkCenter AS [WORK CENTER], QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.ReferenceJobAndLotNumber AS [REFERENCE JOB AND LOT NUMBER], QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.Gauge AS GAUGE, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.BalloonNumber AS [BLN NO]
    FROM QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo
    GROUP BY QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.SessionNumber, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.PartNumber, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.PartName, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.OP, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.IPRev, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.JobNumber, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.WorkCenter, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.ReferenceJobAndLotNumber, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.Gauge, QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.BalloonNumber
    PIVOT QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo.HEADER;

    The Query Named "QueryToSelectDataForFeatureSummaryExportReportNullRefJobLotNo" displays the HEADER field.

    The Query named "QueryToSelectDataForFeatureSummaryExportReport_Crosstab_NullJobL" does not display the HEADER field.

    What am I missing?

    Thursday, January 4, 2018 7:17 PM

Answers

  • Never Mind,  I realized that it is working, I just don't use crosstab queries enough to be that familiar.  It is working just fine, I was just looking in the wrong place,
    • Marked as answer by tkosel Thursday, January 4, 2018 7:23 PM
    Thursday, January 4, 2018 7:23 PM