Time Average

O

Owen

Hello,

I have a report with a field that dispays the difference
between two dates (Date_Issued and Date_Answered), called
TimeOut.

I'd like to have a field that displays the average
difference displayed in the TimeOut fields.

TIA

Owen
 
M

Marshall Barton

Owen said:
I have a report with a field that dispays the difference
between two dates (Date_Issued and Date_Answered), called
TimeOut.

I'd like to have a field that displays the average
difference displayed in the TimeOut fields.

It not exactly clear what you're doing, but try using a text
box (in a group or the report footer section) with an
expression something along these lines:

=Avg(DateDiff("h", [Time In], [Time Out]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top