>Have you tried? I get an error message.

VFP8 doesn't allow a 'group by' clause that does not include all of the fields in the select. The only way to make it work that way is to Set EngineBehavior 70 to make it revert to the way VFP7 worked.

About the only other thing you can do is to make any of the fields that are not to be included in the group by into aggregate fields.

Alan