My apologies. I should have included my entire

Select

pr.ProductName,

ln.LoanType,

lt.LoanProductCode,

Total_Loans= **Count(ln.Balance)**, *--I want this number to include a comma if >1,000*

Total_Balance='$'+Convert(Varchar,Convert(Money,SUM(ln.Balance)),1)

From Loan ln

Join LoanTypeRecord lt

On lt.LoanType=ln.LoanType

Join Product pr

On pr.FxpTypeNumber=ln.LoanType

Where

ln.Closed<>'-1'

AND ln.LoanType In ('2','3','14','15','17','18','19','20','24','26','28','33','38','39','40','41','65','75','79','96','100','101','102','106','111','112','113','114','115')

AND pr.ProductCategoryCode='2'

AND pr.ProductName<>'ZZAZ NEW AUTO VARIABLE'

--AND ln.Balance>'200000'

Group By

pr.ProductName,

ln.LoanType,

lt.LoanProductCode