Very grateful I am to find tiny snippet, so obvious but so nice to find... it made my afternoon much more pleasant. Sometimes the most obvious are the most frustrating.
GROUP BY Format(ReportTbl.lot_date,"mm-yyyy")
ORDER BY MIN(ReportTbl.lot_date);
Many thanks!