Hi Nancy,

>Did you first get the query working w/o the GROUP BY clause, to confirm your join is working correctly?

Yes I did. I end up with 6 identical records for each of the 2 grouped records.

>Also, I believe the GROUP BY clause needs to have all non-calculated fields specified.

I tried this just now. No change.

Thanks for the tip. If you think of anything else. I'm still stumped.

Mike