It's one of those morning after an all-nighter (which I am getting too old for) and I would appreciate it if somebody would point out my error, probably obvious:

Works:

       * REPLACED ACTUAL TABLE NAMES FOR THIS EXAMPLE:
	SELECT a.ccompany, a.custcode, COUNT(b.req_date) as nTotal,  ;
					SUM(b.nstorage) as nStorage, SUM(b.tow_chrg) as nTows ;
				FROM a;
				JOIN b ON b.custcode = a.custcode;
				WHERE b.control_no in ;
					(SELECT towfky FROM redeem WHERE redeem.dredeemdat>= {01/01/2014} AND redeem.dredeemdat<= {12/31/2014}) ;
				GROUP BY 1,2 ;
				into cursor temp1 readwrite 

Now add the ORDER and the totals go haywire

       * REPLACED ACTUAL TABLE NAMES FOR THIS EXAMPLE:
	SELECT a.ccompany, a.custcode, COUNT(b.req_date) as nTotal,  ;
					SUM(b.nstorage) as nStorage, SUM(b.tow_chrg) as nTows ;
				FROM a;
				JOIN b ON b.custcode = a.custcode;
				WHERE b.control_no in ;
					(SELECT towfky FROM redeem WHERE redeem.dredeemdat>= {01/01/2014} AND redeem.dredeemdat<= {12/31/2014}) ;
				GROUP BY 1,2 ;
                                ORDER BY 1,2 ;
				into cursor temp1 readwrite 

TIA