Date Calculation - same field, different record

  • Thread starter Thread starter untiroalaire
  • Start date Start date
U

untiroalaire

Hi,

here's what I'd like to do:

get the time difference (Elapsed) between the "received date" field for
all emails (running total) I've dumped into access from outlook and
summarize at the end.

so, sample input:
From | To | Received Date | Elapsed*
Click to expand...
---------------------------------------------
John | Mary | 24/10/2005 1:27:00 PM -
Mary | John | 24/10/2005 1:30:00 PM 3:00
John | Mary | 24/10/2005 1:35:00 PM 5:00

Total Elapsed Time: 8:00

*Elapsed field is calculated...doesnt exist in Outlook

Is this possible?

Thanks in advance

R.
 
In one query you could return the Min and Max time for the day. In a second
query, Use DateDiff() to calculate the difference.
 
Back
Top