This query is working in the last version of the app. It now throws the error:
"SQL: Column 'GROUPING' is not found."

I am running both the previous version and the new one in VFP9.

SET ENGINEBEHAVIOR 70

SELECT StatName, ;
  ShowTitl, ;
  ClientId, ;
  TTOD(WeekDate) AS WeekOf,;
  SUM(Gross) AS Gross,;
  SUM(DStat_Net) AS DStat_Net,;
  StatName + ShowTitl AS Grouping,;
  COUNT(Grouping) AS Quantity;
 FROM Results;
 GROUP BY StatName, ShowTitl, WeekOf;
 INTO TABLE Results2