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
Ca a query filter out Exclude 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 query 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
Ca a query filter out Exclude 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 query 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.