[AccessD] pivot query

Pedro Janssen pedro at plex.nl
Thu Jan 1 15:15:43 CST 2009


Hello Group,

first all the best for 2009.

I have a pivot query.

TRANSFORM Count(qryPerioden.AX) AS CountOfAX
SELECT qryPerioden.Soort_nr, qryPerioden.Kerkdorp, Count(qryPerioden.AX) AS [Total Of AX]
FROM qryPerioden
GROUP BY qryPerioden.Soort_nr, qryPerioden.Kerkdorp
PIVOT Format([datum],"yyyy");


I want in the same query a statement, so that i get also the count of two periods;
Between #01-01-1980#  and #31-12-1993#              and           Between #01-01-1994#  and #31-12-2008#

I can't have tried, but i can't get it done.

Who can help me?

Thanks

Pedro


More information about the AccessD mailing list