>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.

And that is correct? They should be identical?

>>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.

Actually hadn't had my coffee before so that was just the basics. You do need the grouping fields, though.

As for the rest, would be easiest if you post a small example of the raw data (a few records, enough to show the issue) and the result you would expect. Then we can work from there. At least that's how I'd approach it, but I'm a SQL grunt, not guru.

Please use the < pre>< /pre> tag (w/o the spaces) to format the data.