My Understanding of Distinct is that it forces each record being included in the result set to compare itself to the rest of the records in the result set and only add itself if there are no other matches existng. With the sql example you showed, I would think you'd have to write two SQL statements. The first would give you your distinct list and then your second would give you the sum and counts when you pull it from your first result set.

Dave