G
Guest
how do i create a crosstab query in an ADP application so that I can create a
graph from the data? the query im trying to enter is:
TRANSFORM Sum(Clients) AS SumOfClients
SELECT Date
FROM [Daily Summary Table]
GROUP BY Date
PIVOT Type;
but im getting an unable to parse error.
please any help?
thanks,
ben
graph from the data? the query im trying to enter is:
TRANSFORM Sum(Clients) AS SumOfClients
SELECT Date
FROM [Daily Summary Table]
GROUP BY Date
PIVOT Type;
but im getting an unable to parse error.
please any help?
thanks,
ben