B
BMusic
I have a base query (qselDEQExport2_Test) with the following SQL statement
SELECT qselChemDetail_W_Const.autWellChemDetailID,
qselChemDetail_W_Const.autWellChemID, qselChemDetail_W_Const.autConstID,
qselChemDetail_W_Const.txtConstituent,
IIf([ysnNotDetected]=-1,"ND",[sglValue]) AS [Value],
qselChemDetail_W_Const.sglValue, qselChemDetail_W_Const.autUnitID,
qselChemDetail_W_Const.ysnNotDetected
FROM qselChemDetail_W_Const;
All basic stuff, except for the one Iif statement that creates a column
called "Value"
When I try to build the crosstab query, it will not let me use "Value" in
the SQL
TRANSFORM First(qselDEQExport2_Test.Value) AS FirstOfConst
SELECT qselChemDetail_W_Const.autWellChemID
FROM qselChemDetail_W_Const
GROUP BY qselChemDetail_W_Const.autWellChemID
PIVOT qselChemDetail_W_Const.autConstID;
returns the following error
"The Microsoft Jet database engine does not recognize
'qselDEQExport2_Test.Value' as a valid field name or expression.
How can I get around this?
I have set the parameter "Value" to data type "text" in the query parameter
box in the original query "qselDEQExport2_Test"
Thanks much for the help!
Beth
SELECT qselChemDetail_W_Const.autWellChemDetailID,
qselChemDetail_W_Const.autWellChemID, qselChemDetail_W_Const.autConstID,
qselChemDetail_W_Const.txtConstituent,
IIf([ysnNotDetected]=-1,"ND",[sglValue]) AS [Value],
qselChemDetail_W_Const.sglValue, qselChemDetail_W_Const.autUnitID,
qselChemDetail_W_Const.ysnNotDetected
FROM qselChemDetail_W_Const;
All basic stuff, except for the one Iif statement that creates a column
called "Value"
When I try to build the crosstab query, it will not let me use "Value" in
the SQL
TRANSFORM First(qselDEQExport2_Test.Value) AS FirstOfConst
SELECT qselChemDetail_W_Const.autWellChemID
FROM qselChemDetail_W_Const
GROUP BY qselChemDetail_W_Const.autWellChemID
PIVOT qselChemDetail_W_Const.autConstID;
returns the following error
"The Microsoft Jet database engine does not recognize
'qselDEQExport2_Test.Value' as a valid field name or expression.
How can I get around this?
I have set the parameter "Value" to data type "text" in the query parameter
box in the original query "qselDEQExport2_Test"
Thanks much for the help!
Beth