Chart / Query help

[mousemat]

HELP!!!!!!!!!!!!!!!!!!!!!!

I have been stuck with this for a few days now. (One of those IT contracts which all of a sudden turn nasty - "Oh, we have this database!"

Thanks to Dan-Cat I solved the other problem with the database.

This one is probably really simple but my brain now hurts.

Here is the SQL

TRANSFORM Count([All Accident Chart query].[Report Number]) AS [CountOfReport Number]
SELECT [All Accident Chart query].Month
FROM [All Accident Chart query]
GROUP BY [All Accident Chart query].Month
PIVOT [All Accident Chart query].Year;

Basically I am producing a graph from the abovce sql. All works fine except that I can't get the months to display chronologically (Jan Feb Mar Apr etc etc).

This is due to the fact that they come from a table with two fields in, ID & Month. The month is just a text field.

Is there a way that i can sort the months chronolgically without changing the whole structure of the database?

 

[mousemat]

Ok, I have mad progress with the above problem.

I now have a graph which is seqentail but only shows the months as numbers along the bottom.

Moving on I have chagned the chart query to that of below:

TRANSFORM Count([All Accident Chart query].[Report Number]) AS [CountOfAccident Count]
SELECT [Chart Months].[Chart Month]
FROM [All Accident Chart query] LEFT JOIN [Chart Months] ON [All Accident Chart query].Month = [Chart Months].[Chart Month]
GROUP BY [All Accident Chart query].[Acc Month], [Chart Months].[Chart Month]
ORDER BY [All Accident Chart query].[Acc Month]
PIVOT [All Accident Chart query].Year;


This produces the resultant chart in the format that I require with one problem:

Along the bttom axis all I get is MAY in the correct place. No other text is shown

Anyone??????????

 

[dan-cat]

Can you post the db - then I'll take a look for you

 

[mousemat]

Hi Dan

Can get it to compact small enough, plus as im only a contractor here i dont have email

Ian