Find first created activity

[Carrie]

I am measuring the first outbound activity on a call. Each call is designated a unique call number. You then add activities to the call. So the activities have the same call number but different times the activities were created.

I need to know how to pull a query that only looks at the first created activity time for each unique call number.

Here is the SQL I have so far.

SELECT [Tbl - Activities].[SR #], [Tbl - Activities].Created
FROM [Tbl - Activities]
ORDER BY [Tbl - Activities].[SR #], [Tbl - Activities].Created;


Where SR # is the Call number. Created is the date the activity was created.

 

[Norie]

Try a Totals query grouping on SR# and using Min for Created.

eg

SELECT [Tbl -Activities].[SR #], Min([Tbl -Activities].Created) AS MinOfCreated
FROM [Tbl -Activities]
GROUP BY [Tbl -Activities].[SR #];

 

[Carrie]

This is where I am going with this.

Once we find only the first outbound event for each SR (call). I will then link this query to another table that holds the actual call the customer made.

Here is how it works. A customer calls and we log their call (SR) then when the tech returns thier call and tries to fix this issue they document the call in an activity.

So, when I find the first outbound activity (we know it is the first because of the time it was created) I will link that to the table with all of the SR's.

I then need to somehow find the first response time. That is to say, how long did it take from the time the customer logged the call to the time the tech made thier first outbound activity.

I guess if we can go straight to this last part that would be beneficial.

I hope I haven't made things more confusing. I was actually trying to make them more clear.

Please let me know if you need more information.

 

[Carrie]

Sorry Norie,

I started typing the second part before I saw your reply. I will try that and let you know.

Maybe you can help with the second part?