I have got the answer from http://office.microsoft.com/en-us/ac...001110218.aspx
thanks
shas1928
Last Activity: May 3 '12, 01:39 AM
Joined: Jan 4 '12
Location:
-
Hi TheSmileyCoder
thanks for your replay
the query is for calculating the difference between login time and log out from the table "punching"
punching table
emp id number employee id
login general date
logout general date
total time query
SELECT [punchng].[emp id], [punchng].login, [punchng].[log out], Sum([punchng]![log out]-[punchng]!login)...Leave a comment:
-
how to sum up the total worked hours in access query
HI
i have one column in a query which give total worked hours in the format like 09:00, 08:53.. How can I sum up all those
hours ,
for eg;
emp id date in out total worked
122 12/1/2011 09:10 18:00 08:50
122...
No activity results to display
Leave a comment: