DATENAME(mm, tbl_Claims.clearedDate) + ' ' + DATENAME(yyyy, tbl_Claims.clearedDate) AS monthYear

Then

ORDER BY monthYear

April 2011
August 2011
etc..
And not in actual month order. 

This could become slightly more complicated by the fact it will display totals from 24 months back. So for example i need it to display Jan 2011 to December 2012 in order

select
	DATENAME(mm, dateadd(mm,datediff(mm,0,cc.clearedDate),0) ) + ' ' +
	DATENAME(yyyy, dateadd(mm,datediff(mm,0,cc.clearedDate),0) )
	AS monthYear,
	count(*) as [Cleared Count]
from
	tbl_Claims cc
group by
	-- First Day of Month
	dateadd(mm,datediff(mm,0,cc.clearedDate),0)
order by
	dateadd(mm,datediff(mm,0,cc.clearedDate),0)

quote:

---

Originally posted by Tones

The report has to go back over 2 years though. So i thought ordering that way would have January 2011 then January 2012, February 2011 then February 2012 etc?

---