I used your PersonID to jibe with your example in my reply. Of course I used my field name instead. I want to sum the totals. I don't understand why I would use count. I'm summing values. I get the right totals that way. If I counted I would only get a count of how many values. My example must not be clear. I tried hard to describe it but I realize it's not necessarily clear.

I have a solution using the totals returned by a separate stored procedure. It works. I just thought it was a kludge. I thought that was what you meant in your reply before this last one. I said if you thought it wasn't a kludge I would use it knowing that it was right because you have a high ("ten centuries") experience level.

Now that you are suggesting different functions and that I use count, I'm confused.