There are four columnns and this is an example of the data returned when i run the query
Select * From tbl_log WHERE access_date Between '2011-06-27' And '2011-06-28' AND worker_id=60; /////RESULTS//// user_id Date_accessed signed_in Access_Id 60 2011-06-27 08:45:25.000 1 45844 60 2011-06-27 09:38:04.000 0 44936
At the moment, I am just trying to keep things simple and return a record for a specified day where the user has signed in but not signed out.
Would anyone be able to offer any advice regarding this?
thanks in advance.
This post has been edited by jimmyo88: 28 August 2012 - 03:54 PM