How To Sum OT For the Year

[MFS]

I am having an issue with trying to sum the total amount of OverTime my employees work for the year in a query,
My table consists of "Pay Periods", "Employee_Id" and "OT_Worked" fields,
Each week I enter the overtime hours that my employee worked for that period. What I am trying to do now is run a report for the year showing total amount of OT for all employees.
Thank You for your help,

Speck

[JoeM]

Use an Aggregate Query.
Add the Employee_ID and OT_Worked fields to your query.
Then click on the Totals button (looks like a Sigma).
This will add a Totals row under each field.
Leave the Employee_ID value as "Group By", but change the value under OT_Worked to "Sum".
This should return the total OT_Worked for each employee.