Count days in query

[JiTS]

I got an assignment from my supervisor and I am not getting it!

I have a query (see result in attachment) with the following fields:
tID, emailID, emailtype and EmailDate.

Example:
A customer (tID 1297542) sends an e-mail (emailtype 1) to the company on 2-8-2005.
The company replies on that e-mail (emailtype 3) on 5-8-2005.

Problem:
I would like to create a query that shows per tID the total of days between the e-mail from the customer and the e-mail from the company (between emailtype 1 and 3).

 

[RuralGuy]

AFAIK you can't do it in a query but a report based on that same query can achieve the results you are looking for.

 

[JiTS]

Thanks!

 

[RuralGuy]

Have fun with the project.

 

[brianblenkinsop]

Have you tried running a Crosstab query to an output table showing email types as columns and then in a second query working out the date difference?