I really need help in sovling this problem

[rifat_2000]

You well find attached is an access file wher you have a table called
CLKTRANS that is a check in check out format
id number
date and time check in
date and time check out
and type which repesents 0 for check in 1 for check out

i need help in making a query where i can see how many hours each person worked per check in check out and a total per month

thanks

 

[SimonB1978]

Hi,

I do not have a solution for you problem since I can't figure out on which fields you could possibly group.

Would it be possible for you to have the check in and check out in the same record (IN_DATE, IN_TIME, OUT_DATE, OUT_TIME) ? That would make things a LOT easier.

 

[rifat_2000]

no since the finger print log on log off it store the data in that matter
IN_DATE, IN_TIME
OUT_DATE, OUT_TIME
2 diffrent records

thanks for your reply