employee attendance (1 Viewer)

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

You dont need 2 fields for date/time. 1 is all it takes. The 1 field holds both date and time.

run 2 append queries to append to Result,
Q1 pulls only the IN stamps and adds to the IN date.
Q2 pulls only the OUT stamps and adds to the OUT date field.

then run a query to sum on the same Day. to see IN vs OUT.

Ranman256 said:

You dont need 2 fields for date/time. 1 is all it takes. The 1 field holds both date and time.

run 2 append queries to append to Result,
Q1 pulls only the IN stamps and adds to the IN date.
Q2 pulls only the OUT stamps and adds to the OUT date field.

then run a query to sum on the same Day. to see IN vs OUT.

Click to expand...

thanks my dear ... the Q1 And Q2 is done , but i didnt understand what do you mean about " then run a query to sum on the same Day. to see IN vs OUT"
please can you explain more ?


regards