Date format using Query Wizard group

Question

I created a query with the query wizard and selected to group the data by month.  The query does display the monthly totals but the months are displayed in the "mmmm, yyy" format.         Month: Format$([q-AllOrders-002].[Entry-Date],'mmmm yyyy')

With the months identified in this format, they do not sort in the order I need.  January, February, March, April.....  Instead I get April 2010, April 2011, February 2010, February 2011.....

Is there a way I can have the months display in a format such as 2010 01, 2010 02, 2011 01, 2011 02?

Answer 1

Try 'yyyy mm' or 'yyyymm' as format string.

Answer 2

Perfect - Thanks!  "yyyy mm" give me exactly what I need by putting the date in the format:  2011 01, 2011 02...  Makes sorting the months much easier!