Crosstab Query Date

[Hayton]

Hi Everyone,

I have CTQuery that limits the data to 12 months. I need to be able view 3 years data by month (36 month. Is there a way i can do this.

TRANSFORM Sum([qryGeberal ii].Cost) AS SumOfCost
SELECT [qryGeberal ii].FltDesc, [qryGeberal ii].Axle, [qryGeberal ii].Event, Sum([qryGeberal ii].Cost) AS [Total Of Cost]
FROM [qryGeberal ii]
GROUP BY [qryGeberal ii].FltDesc, [qryGeberal ii].Axle, [qryGeberal ii].Event
PIVOT Format([Date],"mmm") In ("Jan","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");



Hayton McGregor

 

[antvon]

Hi

I'll take a stab at this by suggesting that if you
have a year and month field in your root table/query
you can concatinate them into another field like so 200501 and then run the crosstab based on this.
I have used this recently for 24 month report.
Hope it helps

Cheers

 

[Hayton]

Thanks for the Tip. It worked out.

Hayton McGregor