azhar2006
Registered User.
- Local time
- Today, 08:56
- Joined
- Feb 8, 2012
- Messages
- 202
Hello all .
I am trying to display a crosstab query on a form. This query displays a set of items. What I want to show me the results of the query on an unstructured form.
I am trying to display a crosstab query on a form. This query displays a set of items. What I want to show me the results of the query on an unstructured form.
Code:
TRANSFORM Sum(QueryRank.CountOfRtba) AS SumOfCountOfRtba
SELECT QueryRank.CountOfRtba
FROM QueryRank
GROUP BY QueryRank.CountOfRtba
PIVOT QueryRank.ProductColour;
Last edited: