Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 said:
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 ?
Click to expand...

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
 
I did not get you well,but anyway,it's a text box not field list..

Dave said:
Pietro said:
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 ?
Click to expand...

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
Click to expand...
 
Back
Top