ADP & Crosstab

[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

 

[[MVP] S.Clark]

If your ADP is based on SQL Server, then you can't, because SQL Server
doesn't support Crosstabs. There are many posts(Google) that will guide you
through the process of creating one using code in a Stored Proc.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting