order by month
need some help with displaying months in the correct order on my chart.
here is my recordset:
SELECT MonthPaid AS XLABEL, SUM(Amount) AS YVALUEFROM monthlycommissionWHERE YearPaid= NOW( )GROUP BY MonthPaid
the column is a date column as the WHERE YEAR works fine but i have tried :
ORDER BY MonthPaidorder by MonthPaid
but no joy, also Tried
ORDER BY 'MonthName'ORDER BY 'MonthName'
ORDER BY MONTH Paid = 'MonthName'ORDER BY Month Paid = 'MonthName'
and does not work, it displays the data i need but just looks stupid going from June to March then to January instead of Jan feb etc
can you help impliment into the chart correctly?