Sort calculated field

[ApesMM273]

When I created a query, the wizard created a field grouped by month name and year (April 2003, August 2003, etc.) On the report based off this query, I have that field sorted, but it sorts it by month name rather than month order (April, August, December, February, etc. instead of Jan, Feb, March, etc.) I need it sorted in month order; is this possible?

Also, some months have no data; is there a way to force it to show every month, with a 0 for the months with no data?

The tables I'm using are links to MAS90 tables, so I cannot make any changes at the table level, and I'm dealing with a HUGE recordset. Any help much appreciated.

 

[Joe4]

In a query, add another calculated field, and sort by this one:

MySortField: Format([MyTable]![MyDate],"yyyymm")

For the second part, you can an add an "IF" portion to this that says if the field is blank, return a 0.

 

[ApesMM273]

The sort worked great, thanks! I'll have to work some on getting all months to show.