>I thought the SQL was getting the max() of all the time values into one rec for all the days that the person has punched in and out?
Yes, but when you have GROUP BY it gets MAX values for the group not MAX() of all.
>
>What you mean "HA! Again with old picture?"?
I see your old picture, not that serious one with glasses.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.