cannot group by name using this query

[viveleroi]

This query pulls different vacation time calculations from a table and another query, and calculates items. As it is below it works just fine. Except, it displays each record for each employee, when all we want it to do is sum up the calculations for each employee, and then display the final result.

We Get:

EMPLOYEE: NUM1 | NUM2 | TOTAL3-SO-FAR
EMPLOYEE: NUM1 | NUM2 | TOTAL3-SO-FAR
EMPLOYEE: NUM1 | NUM2 | TOTAL3-SO-FAR

We Want:

EMPLOYEE: TOTAL1 | TOTAL2 | TOTAL3

SELECT tblEmployees.FullName, tblEmployees.PTOAmount, tblEmployees.CarryOverAmount, qryEmplyeesWithUsedPTO.DateUsed, qryEmplyeesWithUsedPTO.Hrs, qryEmplyeesWithUsedPTO.WTCode, qryEmplyeesWithUsedPTO.Description, tblEmployees.Supervisor, tblEmployees.EmpID AS LanID, tblFloat.Hours AS FloatHours, [tblEmployees.PTOAmount]+(Nz([tblEmployees.CarryOverAmount],0)+0)+(Nz([FloatHours],0)+0)-(Nz([qryEmplyeesWithUsedPTO.Hrs],0)+0) AS RemainingAmount
FROM (tblEmployees INNER JOIN qryEmplyeesWithUsedPTO ON tblEmployees.EmpID=qryEmplyeesWithUsedPTO.EmpID) LEFT JOIN tblFloat ON tblEmployees.EmpID=tblFloat.EmpID
WHERE tblFloat.Description=1
ORDER BY tblEmployees.FullName;

 

[Meltdown]

Assuming the query is populating a report and you have the Totals on the report...turn off the visibility of the Details section, right click the Details bar on the report, select Properties, and set the Visible property to NO.

 

[Pat Hartman]

Use a totals query. Open the query in design view. Press the sigma button. Change the group by's to Sum's for the fields you want to sum.