Give this a try for a starter.

SELECT

tblObject_1.Name AS Agent,

COUNT(tblLoan.Object_ID) AS Count,

SUM(tblProcessingFile.LoanAmount_MIP_FF) AS Volume

FROM

tblLoan

INNER JOIN tblObject

ON tblLoan.Object_ID = tblObject.Object_ID

INNER JOIN tblProcessingFile

ON tblLoan.Object_ID = tblProcessingFile.Loan_ID

INNER JOIN tblObject AS tblObject_1

ON tblLoan.ContactOwnerID = tblObject_1.Object_ID

INNER JOIN tblDomain

ON tblObject_1.Domain_ID = tblDomain.Object_ID

INNER JOIN tblObject AS tblObject_2

ON tblLoan.Source_ID = tblObject_2.Object_ID

WHERE

(tblDomain.DomainCategoryTypeID = 2) AND

--(tblProcessingFile.Funded IS NOT NULL) AND -- Not needed due to criterea below

(tblLoan.Expected_Close_Year = 2012) AND

--(tblProcessingFile.Funded BETWEEN @Stardate AND @Enddate)

tblProcessingFile.Funded >= dateadd(mm, datediff(mm, 0, getdate()), 0) and

tblProcessingFile.Funded < dateadd(mm, datediff(mm, 0, getdate()) + 1, 0)

GROUP BY

tblObject_1.Name

ORDER BY

Count DESC,

Agent;