I am in problem & have to solve one query.
I have a one table with the empno, employee time in & time out, data, employee can go out & come in fequently in a day.
I want to know that how much time every emp have attend in the company per day.
I want to know that how much time every emp have not attend in the company per day(once he enter at morning and he come out in the end of the day)
Kindly, do reply as soon as possible.
I am enclosing data defination in txt file along with the data in the MS Excel file.
Thanx in Advance...
The Table Like this
Create table emptime
View Complete Post