Format 'mmmmyyyy' 1

[lakers8175]

I have a query where I am formatting the date to mmmmyyyy, That formatted field is a grouping on my report that I want to sort by. The problem is it's sorting the by the alpha and not the date. How do I get it to sort by date?
here is wht is currently looks like on the bad sort.

April 2008
April 2009
Decemeber 2008
Febuary 2009

 

[PWise]

have the date field as
format(date,"yyyymm") for sorting And grouping
and
format(date,"mmmmyyyy") for Display

 

[lakers8175]

Thank you, thank you, it worked!!!!!

 

[dhookom]

lakers8175,
It would be appropriate to thank pwise by clicking the purple star link. This shows appreciate to pwise and marks the thread as being resolved

Duane
Hook'D on Access
MS Access MVP