C
carl
Can a query do the following:
ExternalSymbol(NewId"N") and ExternalSymbol(NewID "N+1") are not equal AND
Duration1(NewID "N+1") is less than 0:00:05.
Here's the original table:
NewID NewTime Duration1 ExternalSymbol
1 9:31:16 A
2 9:31:37 0:00:21 B
3 9:31:41 0:00:04 B
4 9:31:50 0:00:09 C
5 9:31:53 0:00:03 D
6 9:32:02 0:00:09 E
Here's the table I am trying to create:
NewID NewTime Duration1 ExternalSymbol
1 9:31:16 A
2 9:31:37 0:00:21 B
4 9:31:50 0:00:09 C
5 9:31:53 0:00:03 D
6 9:32:02 0:00:09 E
Thank you in advance.
ExternalSymbol(NewId"N") and ExternalSymbol(NewID "N+1") are not equal AND
Duration1(NewID "N+1") is less than 0:00:05.
Here's the original table:
NewID NewTime Duration1 ExternalSymbol
1 9:31:16 A
2 9:31:37 0:00:21 B
3 9:31:41 0:00:04 B
4 9:31:50 0:00:09 C
5 9:31:53 0:00:03 D
6 9:32:02 0:00:09 E
Here's the table I am trying to create:
NewID NewTime Duration1 ExternalSymbol
1 9:31:16 A
2 9:31:37 0:00:21 B
4 9:31:50 0:00:09 C
5 9:31:53 0:00:03 D
6 9:32:02 0:00:09 E
Thank you in advance.