Ok here is my situation, I'm trying to do a Distict(claim_number count) and Group by Process_Date, but I also want to bring back additional colums such as Net, Billed, Allowed, Copay_Amt, IPA_Amt_To_Pay. The problem is that everytime I add the additonal columns to the query the Count(Distinct Claim_Number) no longer works ok here is the actually query and see if anyone of you guys can help.

Select Count(Distinct Claim_number) AS Claim_Number, Process_Date
FROM dbo.dailyClaims
WHERE Process_Date BETWEEN '06/01/2005' AND '09/30/2005' AND IPA_ID = '823'
GROUP BY process_Date
ORDER BY Process_Date

Remeber I want to also bring back "Net, Billed, Allowed, Copay_Amt, IPA_Amt_To_Pay" so that I can do some math calculations on these fields.