Hi Dears ...
i have a table contain (Date,Time,Access_Reader,Employee_Name,ID) ... this data from the Bio-metric Access
how can i change the time of the login and logout to the vertical to make some calculation on it ...like the delay and early or missing ...etc
the attached file contain MS access DB contain 2 tables
1- IN_OUT_Check --> the data from the bio-metric
2- Result --> the data that i need it look like
thanks and regards
i have a table contain (Date,Time,Access_Reader,Employee_Name,ID) ... this data from the Bio-metric Access
how can i change the time of the login and logout to the vertical to make some calculation on it ...like the delay and early or missing ...etc
the attached file contain MS access DB contain 2 tables
1- IN_OUT_Check --> the data from the bio-metric
2- Result --> the data that i need it look like
thanks and regards