Hello..
Hopefully this is my last question...
I would like to sum the total hours worked for each employee in a report... right now my report is displaying the total hours for each day, so I have Eric listed 5 times because he worked 5 days, and his hours for each day are listed next to his name... i just want his name to show up once, with his total hours... then the same thing for each employee... i made a query that calculates teh total hours for each day they work, but now I need to calculate the sum of hours all together for that employee...
Expr1: HoursAndMinutes([TimeOut]-[TimeIn])
that is my code for total hours for that one day... in my query.
thanks again. kim
Hopefully this is my last question...
I would like to sum the total hours worked for each employee in a report... right now my report is displaying the total hours for each day, so I have Eric listed 5 times because he worked 5 days, and his hours for each day are listed next to his name... i just want his name to show up once, with his total hours... then the same thing for each employee... i made a query that calculates teh total hours for each day they work, but now I need to calculate the sum of hours all together for that employee...
Expr1: HoursAndMinutes([TimeOut]-[TimeIn])
that is my code for total hours for that one day... in my query.
thanks again. kim