Month sum

[ladybug via AccessMonster.com]

I have a query called qryOrders&Scripts.
The Fields are chrProgramShortName, ShipDate, Total Orders, TotalScripts,
Expression

Each entry is for one date. I want to group the entries together by month.
How do I do this?

 

[Guest]

Add a calculated field to sort on like this ---
Year_Mon: Format([ShipDate], "yyyymm")