Re: Query w/sum and GROUP BY for related tables?

[craig scyuli]

ok. so would this work if users clocked in and out multiple times on the same date?

Also, just to be clear, you are saying that when they clock in I should create a new row, but when they clock out I should first find the row where they clocked in and UPDATE the "t_out" field with a timestamp?

The update should be through a SQL update query not a trigger.

Please advise. thanks so much.