View Single Post
  #1  
Old June 6th, 2010, 07:26 PM posted to microsoft.public.access.reports
jackie
external usenet poster
 
Posts: 216
Default Trying to calculate difference between two times in an access repo

I am trying to calculate the difference between two times in an access report
and don't know what the correct expression is.
My report has a column of "Start" and "End" that has the start time of the
project and the end time of the project. I need the difference between the 2
so I created an expression for "Total production time" -
=timediff("h",[end],[start]) but a box keeps appearing when I try to view the
report which means I have an error and I don't know where I went wrong