Add overtime totals from 1st of the year to present

[MFS]

Hello,
For some reason I cannot get this figured out, I'm looking to have a query return total overtime hours that each employee has worked through the year, starting with 1/1/2015.
The fields in the Query are . . .

• Period Ending, (Pay period end date, Typically every Sunday)
• Total Overtime Hours Worked, (How many hours over the employee worked during that period)
• Employee_Id

Example: Kelly Smith 3
Dave Hart 22
Scott Davidson 17

What I'm getting is . . .
Kelly Smith 2
Kelly Smith 1


Dave Hart 20
Dave Hart 2
Scott Davidson 10
Scott Davidson 17

Hope someone can help,

Speck

[pbaldy]

I suspect you are grouping on the period. It should just be Where, not Group By.

[MFS]

Got it,
I removed Period_Ending from the Query and Summed Total Overtime Hours Worked.
I feel like a marooon.

Thanks all

[MFS]

pbaldy, I can look into that scenario as well.

Thank You

[pbaldy]

If you want to filter on the period, you have to leave it in the query, but with Where in the totals row. In SQL view, that would take it out of the SELECT and GROUP BY clauses but leave it in the WHERE clause (or HAVING).