Using CR XI, i need to create a bar graph with the x axis having months, i want CR to arrange these months in order of Jan to Dec, i am failing to do this. I created a query(command) to do this but in vain.
In Access, a query like this and ordering by first(Date) does the trick.
Any Ideas!!Code:SELECT fQryIncidents.Month, Sum(fQryIncidents.No_Of_IDPs_Affected) AS [No Of IDPs Affected], Sum(fQryIncidents.No_Of_NGOs_Affected) AS [No Of NGO People Affected], Sum(fQryIncidents.No_Of_UN_Affected) AS [No Of UN People Affected], Sum(fQryIncidents.No_Of_Civilians_Affected) AS [No Of Civilians Affected] FROM fQryIncidents GROUP BY fQryIncidents.Month ORDER BY First(fQryIncidents.Incident_Date);


Reply With Quote