Combine two columns into one in a crosstab query

[EAB1977]

Is it possible to combine two columns in one in a crosstab query? For
example:

TRANSFORM First(qryVDRProductionRuns.TestValue) AS FirstOfTestValue
SELECT dbo_vwPlant.Name, qryVDRProductionRuns.ProductCode,
qryVDRProductionRuns.PositionRow, qryVDRProductionRuns.ProductionDate
FROM dbo_vwPlant INNER JOIN qryVDRProductionRuns ON dbo_vwPlant.Code =
qryVDRProductionRuns.PlantCode
GROUP BY qryVDRProductionRuns.Key, dbo_vwPlant.Name,
qryVDRProductionRuns.ProductCode, qryVDRProductionRuns.PositionRow,
qryVDRProductionRuns.ProductionDate, qryVDRProductionRuns.PlantCode,
qryVDRProductionRuns.ProductionDate, qryVDRProductionRuns.ProductCode
ORDER BY qryVDRProductionRuns.ProductionDate,
qryVDRProductionRuns.PlantCode, qryVDRProductionRuns.ProductCode
PIVOT qryVDRProductionRuns.TestID;



Name ProductCode PositionRow ProdDate 1
2 3 4 5

One 12 1 1/1/2008
5.5 4.5 1 B 4.5


What I want to display is

One 12 1 1/1/2008
5.5 4.5 1B 4.5

 

[Duane Hookom]

Your posting is a bit scattered. The "First" of Value can contain several
field concatenated together. You can also use IIf() and other types of
expressions.