select det.specDesc, det.surgeon, SUM(det.doccount) as doccount, ...>I'm still working on this darn thing, thought I had it until I went through the details. If I just run the detail part of the query by itself, I get the right number of detail records 33. If I run the complete thing returning the summary values, I get a doc count of 27. I've got it filtered for testing to just one doctor.