Query to show sum of hours

[Elmobram22]

Hi all,

I am trying to build a query to show the total sum of hours a staff member has done in a certain department and the amount of sleep ins they have done. Each staff member has a unique ID. In the query I can get all the information but it shows on two lines dependent on department. I want this to show on a single line. Each employee will never have more than two departments. Any help would be greatly appreciated. The query is called "QryForForum".

Cheers,

Paul

 

[llkhoutx]

Anyone who downloads a database and opens it is setting themselves up for a disaster. It's very bad practice to do it or to ask people to do it.

Query and sum your query result, with appropriate grouping.

 

[Elmobram22]

It's your choice whether you download it. 5 people felt it was ok to.

Thanks,

Paul