I need to find the first occurance of something.

[Carrie]

I need to find what time the first occurance of an outbound event occured.

Currently I have...

SELECT Call.OpenDate, Call.Call_Num
FROM Call
WHERE (((Call.OpenDate)>=[Start Date] And (Call.OpenDate)<=[End Date]));

I need to find out who opened the call and the Time (which opendate shows the time as well as the date). I need to know who made the first contact with the customer after the call was opened. And what time they made it.

The outcome is to find how long it took person A to call back the customer.

I will know that the customer was called back because the tech (person A) will need to comment the call and put the direction of the call.

Commenting the call is called an Event and the direction is either inbound or outbound. I need the first outbound event after the call was opened.

The tabe that the event stuff comes out of is called.

Table Event
Record contactdirection.

Please help.

 

[Mr Ed]

Sounds like you need a nested query. See if you can adapt this to your needs.

SELECT T_sales.client, T_sales.sale_d
FROM (
SELECT Min(T_sales.sale_d) AS Minimum
FROM T_sales ) AS mini
INNER JOIN
T_sales
ON
mini.Minimum = T_sales.sale_d

 

[Carrie]

SELECT T_sales.client, T_sales.sale_d
FROM (
SELECT Min(T_sales.sale_d) AS Minimum
FROM T_sales ) AS mini
INNER JOIN
T_sales
ON
mini.Minimum = T_sales.sale_d

That sounds great except what does this mean.

I appologize that I don't understand but I am learning access by doing and I have no idea what a nested querey is or how to use one.

Could you please help a little more?

 

[icusawme]

When you select to view a query you have 3 choices, table, design and SQL. The text in the responses to your question are in SQL.

 

[Carrie]

I appreciate your help...

I knew about the SQL view but what I don't understand is what the words mean.

I don't understand how you know when to use SELECT, WHERE, WHEN, WHY AND HOW.

I know those aren't really the right words but that would just show you how much I know.

I looked on the help and it doesn't really explain why you use them and when. I think this is the key to my understanding. I think if I can understand them then I could understand a lot more of everything.

Thanks for replying.

 

[icusawme]

You can build a query, then from Views menu select totals. The totals gives you several options one of which is First. This may help,
Then if you select SQL it will show you where access uses the Where When and all that other sql stuff, I have to admit I am a SQL wimp and even if I use SQL code I still let access build it for me.

Hope this isn't even more confusing