Formaula on the report?

[Greg]

I am calculating time difference between start and end time on my main form.
I found function on web Elapsed time that works great. Control source is set
to
=IIf([txtStartTime]>=0,ElapsedTimeString([txtStartTime],[txtEndTime])," ")

I would like to move this calculation and show the result on my report (ex.
show start time, end time, then have a filed on my report that will show time
difference for each occurrence. ) What is the best way to do that?

 

[John Spencer]

It is usually best to assign the expression as the control source of a textbox.

HOWEVER, if you need to filter, sort, or group using the expression then you
would need to use the expression as a calculated column in the report's record
source.

Also, you will need to refer the field names and not the names of the controls
when you are doing this in a query.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County