Has anyone encountered errors when converting from Fox5 to Fox8 concerning macro substitution within SQL statments. I am recieving error "Group by clause is missing or invalid" from Fox8 but Fox5 runs perfectly. I have narrowed it down to the macro substitution elements within the statement. I was curious to find out if anyone else may have encountered this problem.

Thanks in advance,