I m making a software which calculates the hours worked by each employee per day. This is calculated by the in time and out time of the employee. I have the database which contains the in time n outtime of the employee in sql.
Now, My problem is i want to show a table in vb6 form where all the days of the months are in columns and one rown in the left contains the emp_code and the rows below the days of the month contains the hours worked by the employee.
2008-07-29 12:19:49.000 1
2008-07-31 11:38:32.000 1
2008-07-31 12:34:14.000 1
2008-07-31 20:23:00.000 1
2008-07-31 20:23:11.000 1
2008-07-31 21:06:55.000 1
2008-07-31 22:42:37.000 1
2008-08-01 07:49:33.000 1
This is the sample database from which the max time per day is out time and min time is the in time.
here 1 is the emp_code and 6 5 7 8 are hrs worked on the days 1,2,30,31 respt.
Days 1 2…. 30 31
1 6 5…. 7 8
and when the user click on hours on the abv eg 6 he should see the in time and out time.
Which controls i should use dont think Crystal report will work as i have to click on hours and the user can change the out time (ofcource authentication require.)