Hi Guys
Please help!. I am trying to calculate time worked per day and then for the full month. I have a table with [TimeIn] and [TimeOut]. I have used the HoursAndMinutes Public Function to calculate time worked per day.

- HoursWorked: HoursAndMinutes([TimeOut]-[TimeIn])

Now I need to add all the answers together to get how many hours worked per month. When I do this on the report, I just get "Data Type Mismatch".

What do I do?

thanks
Liz

Are you calculating this in the report, or do you put the numbers together in a query first? You should put it together in a query first.

What do the fields look like? And where are you storing HoursWorked? Is that a field alias from a query, or are you trying to store that in a table? If the latter, what is the field type? And why in a table? =)


mmcdonal