Hi Mo -
I was just commenting on the fact that VFP 8 doesn't like it if you don't include all non-aggregated fields in your GROUP BY clause. As Larry Miller said in his response to my original post, you can bypass this behavior by using the SET ENGINE BEHAVOR command.