Date Calculation - same field, different record




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*
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


[MVP] S.Clark

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

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