problems creating a Total field

[jeo]

I have this query that I'm tryin to create a new field in - Total:Sum([Hours])
For each person I need to know how many hours they worked.
I'm linking to a SQL server table which I created a query from and now trying to add this field Total into this query.
It is hard to explain the problem I'm having, so I'm attaching a screen shot.
Any ideas as to why it's giving me an error?

 

[Rich]

Just change it to a Totals query and GroupBy last name, Sum HoursWorked,
press the Sigma button on the toolbar to create the totals query

 

[jeo]

I changed it to a Totals Query, but if I have more than 1 time entry (different dates) for 1 person, it just sums the hours worked on that day and not total hours for that person.
Did I do something wrong?
Thank you for all your help!
Attached is what my query looks like now.

 

[jeo]

Thank you! That works.