K
KARL DEWEY
When I use a query such as below for a crosstab query source it gives an
error message that it does not reconogize T.Column1 as valid. In the past I
have used the query to make a temporary table then the table as source for
the crosstab.
SELECT Column1, Column2, (SELECT COUNT(*)
FROM [YourTable-4] T1
WHERE T1.Column1 = T.Column1
AND T1.Column2 <= T.Column2) AS Rank
FROM [YourTable-4] AS T
ORDER BY Column1, Column2;
error message that it does not reconogize T.Column1 as valid. In the past I
have used the query to make a temporary table then the table as source for
the crosstab.
SELECT Column1, Column2, (SELECT COUNT(*)
FROM [YourTable-4] T1
WHERE T1.Column1 = T.Column1
AND T1.Column2 <= T.Column2) AS Rank
FROM [YourTable-4] AS T
ORDER BY Column1, Column2;