Hi,

I am having a problem with the following statement when running form an exe, but not when runing the project in development. The message is "GROUP BY clause invalid or missing".

SELECT S.*, ;
       SUM(IIF(ExtAmt # 0 AND InvAmt # 0,ROUND(ShippedQty/IIF(SellFrac=0,1,SellFrac),2),000000.00)) AS CajasVenta, ;
       SUM(IIF(ExtAmt = 0 AND InvAmt # 0,ROUND(ShippedQty/IIF(SellFrac=0,1,SellFrac),2),000000.00)) AS CajasPromocion, ;
       SUM(IIF(ExtAmt = 0 AND InvAmt = 0,ROUND(ShippedQty/IIF(SellFrac=0,1,SellFrac),2),000000.00)) AS CajasMuestra ;
  FROM CustomerHistSummary_ConRenglonesCajas_TrandateRange S ;
 WHERE &tcWhere ;
 GROUP BY 2 ;
 INTO CURSOR (tcAlias)

Any ideas? TIA,

Alex