Last record

[mathewheys]

Hi All

I am trying to find the record time stamp for ID between dates
First record: = if 118655 is between 15/7/05 and 15/7/05 ANSWER
12:43:23
Last record: = if 125092 is between 15/7/05 and 15/7/05 ANSWER
10:01:05

Thanks in advance.


A/

B/

C
Date/

id

Time
15/07/2005 118655 12:43:23
15/07/2005 118655 16:54:19
16/07/2005 118655 07:59:43
15/07/2005 125092 08:29:37
15/07/2005 125092 10:01:01
15/07/2005 125092 10:01:05
16/07/2005 125092 10:27:01​

 

[duane]

sorry, I do not understand your question

 

[mathewheys]

sorry, I do not understand your question.

I have updated what i am trying to do

 

[Bob Phillips]

First, keep to the same thread please.

Second, it is not clearer to me.