Help with Query criteria?

[MFS]

Wow, wasn't even sure how to title this post.!!
Here's what I got . . .
I have a database where I keep employee overtime hours. In the database my queries are designed to show total overtime hours employees have worked and total hours of overtime that has been offered to them. I then use this to offer overtime each week, by shift.


Here is what I have, Example below,


John Smith Clock #: 114 Total OT Hours worked = 200 Total OT Hours Offered = 270 Shift: A
Don Grody Clock #: 94 Total OT Hours worked = 201 Total OT Hours Offered = 270 Shift: A
Sam Riles Clock #: 22 Total OT Hours worked = 197 Total OT Hours Offered = 270 Shift: A


Dave Keepers Clock #: 400 Total OT Hours worked = 168 Total OT Hours Offered = 270 Shift: A
John Smith Clock #: 114 Total OT Hours worked = 200 Total OT Hours Offered = 270 Shift: B

John Smith has been transferred to A Shift permanently, but he is seen in the report twice because he also worked on B shift throughout the year. I want to be able to show all Overtime hours he has worked but only show him on the report once.
How could this be done, easily?

[CJ_London]

remove shift from your query

[MFS]

Removing shift from my query would be an easy fix, however I'm filtering my report by shift.
All employees on A shift are shown 1st on the report,
Further down on report shows B shift employees and so on.

[CJ_London]

you can still filter on shift - but the reality is if John Doe is in shifts A and B then you will have two rows

The only other alternative is to show the latest shift rather than group by which shows them both - be aware (if not already so) that first/last/next/previous means nothing in databases without some element of order, be it a date, incrementing UID or similar so you may need to sort your query