>I've always had the bad habit of not including all
>non-aggregated fields in my GROUP BY clauses. Now
>that I've made the upgrade to VFP8, I wish I would
>have. That will teach me.

Frank,
VFP 8 does offer the SET ENGINEBEHAVIOR command if you want to give yourself some time to adjust.

That was the nice me. The not-so-nice me would have said:

Serves you right for writing such statements! ;-)

Regards.