while creating a crosstab query throws below error. The source is another query having a calculation. please help how to rectify this.
Crosstab Query
Source Query - qryDataSequence
Error as below. I have added a parameter to crosstab query as someone suggested but still, I am missing something.
*minor edit was done to add source query name.
Crosstab Query
Code:
PARAMETERS qryKPIDataEntered.KPI_Code Text ( 255 );
TRANSFORM First(qryDataSequence.Calculation) AS FirstOfCalculation
SELECT qryDataSequence.KPI_Title, qryDataSequence.Target
FROM qryDataSequence
GROUP BY qryDataSequence.KPI_Title, qryDataSequence.Target
PIVOT qryDataSequence.EntrySequence;
Source Query - qryDataSequence
Code:
SELECT (SELECT COUNT(*)+1
FROM qryKPIDataEntered AS T2
WHERE T2.KPI_code = qryKPIDataEntered.KPI_code AND qryKPIDataEntered.Action_Date < T2.Action_Date) AS EntrySequence, qryKPIDataEntered.*
FROM qryKPIDataEntered;
Error as below. I have added a parameter to crosstab query as someone suggested but still, I am missing something.
*minor edit was done to add source query name.
Last edited: