CrossTab Query question

[lite4d]

I have a crosstab query that I pull the last 12 months of data from but when I update the data it puts the new data at the end of the columns. I have attached a pic of the data and you can see where it should go. How do i sort it to ensure that the columns go where they should.

Thanks in advance,

Chris

 

[JHB]

Show the SQL-String.

 

[lite4d]

Here is the SQL statement. I have put in the "IN" statement with the months but it didn't do what I am looking for. I tried the "(JAN, FEB....) but I want it to show the last 12 months depending on the data that is in the table.

Thanks for the help!

Chris

 

[JHB]

You are aware of you can move the column after the query shows, if you mark the header and move it?

 

[lite4d]

Yeah but I am going to give this to people that don't know access to use and I don't want them to have to do too much to get the info where it needs to be.

 

[JHB]

Do you've some sample data, then post them.
How do you user open the query, directly by clicking on the query or, (I'm thinking on some VBA code to sort it out, but it would not work if they click directly on the query)?