display months in order

[teel73]

I have a crosstab query that I'm using as my source for a bar graph. I want to show the total of events that occurred between 1/1/2011 and current.
So my fields in my query are setup as follows:

[EventTitle] - group by - row heading

(Format([DateEvent Began],"MMM 'YY")) - group by - column heading

[EventID] - count - value

[EventTitle] - where - criteria (In ("Alarm Activation: Actual Fire","Alarm Activation: False Alarm","Medical Emergency")

[DateEvent Began] - where - criteria (between 1/1/2011 and Date())

This query displays correctly except the months are in alphabetical order and not the order in which the should be: See below
Security Event TypeApr '11Feb '11Jan '11Mar '11May '11Alarm Activation: False Alarm12551Medical Emergency71375Power Outage/Failure22211Theft of FM Property: Laptop1633


how do I set up my crosstab to display the months in the order of the calendar. Jan, Feb, Mar, Apr, May?

 

[rainman89]

Take a look at this

http://www.techonthenet.com/access/functions/date/month.php

Then sort by that

 

[Beetle]

Open your query in design view, select View > Properties. In the Column Headings property put (for example);

"Jan", "Feb", "Mar", ... (etc.)

This will force the query to display the columns in the order you choose.