C
carl
My database looks like this:
ID Time Date Code
1 93116 20060403 UMUD06C30.00
2 93137 20060403 QAAE06C65.00
3 93141 20060403 QAAE06C65.00
4 93150 20060403 DLQD06C30.00
Is it possible for a query to do the following:
Result TimeDiff Time1 ID Time Date Code
Keep 9:31:16 1 93116 20060403 UMUD06C30.00
Keep 0:00:21 9:31:37 2 93137 20060403 QAAE06C65.00
FilterOut 0:00:04 9:31:41 3 93141 20060403 QAAE06C65.00
Keep 0:00:09 9:31:50 4 93150 20060403 DLQD06C30.00
Basically filter out Record 3 based on the logic: If Record "N" Code is the
same as Record "N+1" Code and the difference between Record N+1 Time and
Record N Time is less than 5 seconds.
I think the quesry needs to reformat my Time data as well (Time1 Field)
although it is not necessary for Time1 to be displayed in the query result.
Thank you in advance.
ID Time Date Code
1 93116 20060403 UMUD06C30.00
2 93137 20060403 QAAE06C65.00
3 93141 20060403 QAAE06C65.00
4 93150 20060403 DLQD06C30.00
Is it possible for a query to do the following:
Result TimeDiff Time1 ID Time Date Code
Keep 9:31:16 1 93116 20060403 UMUD06C30.00
Keep 0:00:21 9:31:37 2 93137 20060403 QAAE06C65.00
FilterOut 0:00:04 9:31:41 3 93141 20060403 QAAE06C65.00
Keep 0:00:09 9:31:50 4 93150 20060403 DLQD06C30.00
Basically filter out Record 3 based on the logic: If Record "N" Code is the
same as Record "N+1" Code and the difference between Record N+1 Time and
Record N Time is less than 5 seconds.
I think the quesry needs to reformat my Time data as well (Time1 Field)
although it is not necessary for Time1 to be displayed in the query result.
Thank you in advance.