Linked Table Wages calculated in query

[supa_sumo]

I have two tables linked in this query. The tblStaffHours and tblStaffDetails The tblstaffhours contains the hours worked and the date in which those hours are worked and tblStaffDetails containg all the staffs information including Hourly Rate . I tried to run a query that would add display the Staff details and the Hours worked. The Problem is that when i run it it displays the staff details for every day that they have worked. What i want is for it to display the staff details with a calculated field containing the total hours worked.

What have i done wrong?

 

[maxmangion]

use a total query, and group your records by the StaffID.

 

[mresann]

In addition, ensure the field that shows the days NOT part of the groupings.