Hi Kirk,

Shouldn't it be SUM() not COUNT()?

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.
>
>Thanks for any help.
>
< snip >