Month sum

  • Thread starter ladybug via AccessMonster.com
  • Start date
L

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?
 
K

KARL DEWEY

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