>The .AND. that you've added clarified the issue. I often read each sentence as a rule to be applied to the situation, and I missed the inference that the last sentence/rule applied to ths SELECT field list as well as the GROUP BY list.
>
>Thanks for helping me figure it out.
You're welcome.
--sb--