Hi,
The SQL - 'Group By..' clause is changed in VFP8 to make sure it stated to ANSI92 standard. Make sure all of the fields (beside of aggreation field) in your SELECT....From is included in GROUP BY clause.
HTH
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...