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 there a way to filter out (Exclude) Record 3 based on the logic: If ID
"N"
Code is the same as ID "N+1" Code and the difference between Record N+1
Time and Record N Time is less than 5 seconds.
I think the query needs to reformat my Time data as well (Time Field)
although it is not necessary for Time 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 there a way to filter out (Exclude) Record 3 based on the logic: If ID
"N"
Code is the same as ID "N+1" Code and the difference between Record N+1
Time and Record N Time is less than 5 seconds.
I think the query needs to reformat my Time data as well (Time Field)
although it is not necessary for Time to be displayed in the query result.
Thank you in advance.