Only want the last 6 months rotating

[Thompyt]

How can I have a rotating count of the last 6 months?



Additionally I would like to have the columns Calendar sequenced by Month Year.

This is my Crosstab table:

TRANSFORM Count([Inq_ID])-1 AS [Count]
SELECT Inquires.Section
FROM Inquires
WHERE (((Inquires.Section)<>"0") AND ((Inquires.[Date Sent]) Between DateSerial(Year(Date()),Month(Date())-5,1) And DateSerial(Year(Date()),Month(Date())+1,0)
GROUP BY Inquires.Section
ORDER BY Inquires.Section DESC
PIVOT Format([Date Sent],"mmm yyyy");

This is my output: (Each Column is "mmm yyyy")

"Aug 2014" "Jul 2014" "Jun 2014" "Nov 2014" "Oct 2014" "Sep 2014"

Thanks

[June7]

If you want the sequence by Month Year then must use month number, not alpha.

Format([Date Sent], "mm yyyy")

[Thompyt]

Thanks that fixes one issue. Now to figure out a crosstab query in the report!

[June7]

Building report to run perpetually based on crosstab is not easy because of dynamic nature of crosstab fields. Review (including the additional links in that article) http://allenbrowne.com/ser-67.html

[Thompyt]

June7
This is what I used and still get rotating months. I use six of the columns in the report 1, 0, -1, -2, -3, -4

TRANSFORM Count([Inq_ID])-1 AS [Count]
SELECT Inquires.Actual
FROM Inquires
GROUP BY Inquires.Actual
ORDER BY Inquires.Actual
PIVOT Year([Date Sent])*12+Format([Date Sent],"mm")-(Year(Now())*12+Format(Now(),"mm"))+1;