I have a database that has start and end times in it. In order to find the amount of time spend, I created a calculated field in my query. I used the following formula:

Format([StartTime]-1 -[EndTime], "Short Time")

My query works great, but when I attempt to run my report I get an error:

The Microsoft Jet database engine could not execute the SQL statement because it contains a field that has an invaldi data type.

I know that I am getting this message because my Total Hours field has been changed by the above format. I need to total these hours.

HELP!
Mamaw

Mamaw,

Can you separate the transaction into to parts...do the calculation then use your form or report to format the result as 'Short Time'?
:)

:) Thanks. Sometimes you are too close to the problem to see the light.