I don't belive such query is a valid VFP query, because calcualted field cannot be used in consequent fields exprerssion. Would this work for you?

   COUNT(*) AS Quantity;

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