>Hopefully I haven't missed the point here, but the new VFP 8 requires you to list all query fields in the group by expression - I would group your statement by 2,1,3 and see if that does the trick.

This approach creates unexpected results. I've been dealing with that last night and decided not to go in that direction. I'll follow Sergey's advice. Thanks