Domain Sum Error

[benjaminporter.dc]

Hello,



Thanks in advance for any help you can provide. I'm trying to use a domain sum function in a query to simultaneously show the employee id, salary for each employee, and the sum of all salaries in the domain (tblEmpDet).



SELECT tblEmpDet.EMPLOYEE_NUMBER, tblEmpDet.BASE_SALARY, DSum([tblEmpDet]![BASE_SALARY],"tblEmpDet") AS SumSalaries
FROM tblEmpDet;

What I wind up with is Emp Number, Salary, and instead of a domain sum, I get the salary multiplied by 100.

Any thoughts?

[benjaminporter.dc]

It appears that the function is multiplying the salary by the number of records in the table (100 records).