Chart

[Guest]

Hi all,
I have a problem with my chart,i used the following code in its rowsource:
SELECT [Month2],Sum([Cases]) AS [Number of Cases] FROM [RMonthly] GROUP BY
[Month2];
But actually the months are put in alphabetical
order,February,January,March...ecc
Instead of January, February,March..ecc.
Can anybody help ?

 

[Guest]

Hi all,
I have a problem with my chart,i used the following code in its rowsource:
SELECT [Month2],Sum([Cases]) AS [Number of Cases] FROM [RMonthly] GROUP BY
[Month2];
But actually the months are put in alphabetical
order,February,January,March...ecc
Instead of January, February,March..ecc.
Can anybody help ?

Pietro,
If the [Month2] data is being extracted from a date field, try returning the
serial value of the entire date first by using Int([NameOfYourDateField]) and
sorting on that.
Hope that helps.

Dave

 

[Guest]

I did not get you well,but anyway,it's a text box not field list..

Hi all,
I have a problem with my chart,i used the following code in its rowsource:
SELECT [Month2],Sum([Cases]) AS [Number of Cases] FROM [RMonthly] GROUP BY
[Month2];
But actually the months are put in alphabetical
order,February,January,March...ecc
Instead of January, February,March..ecc.
Can anybody help ?

Pietro,
If the [Month2] data is being extracted from a date field, try returning the
serial value of the entire date first by using Int([NameOfYourDateField]) and
sorting on that.
Hope that helps.

Dave