expression for time sheet returns type mismatch

[jpstormy]

I am trying to create a time sheet for appointments that tells how long each
appt lasted so I can bill them per hour. The expression I have entered with
the builder is
Session Time: Sessions![End Time]-Sessions![Start Time]
but it tells me there is a type mismatch error, but they are both times.

 

[John W. Vinson]

I am trying to create a time sheet for appointments that tells how long each
appt lasted so I can bill them per hour. The expression I have entered with
the builder is
Session Time: Sessions![End Time]-Sessions![Start Time]
but it tells me there is a type mismatch error, but they are both times.

Take a look at the VBA help for DateDiff(). Are Start Time and End Time fields
in your table, or controls on a form? If controls, then they will be seen as
Text values (which would explain your error message).