finding duplicates in a query

B

brian.cole

I have the following query.

Sites Date Circuit Status
Num

PNE038 11/20/06 22:01:03 x25CircuitDown - Critical 1
PNE038 11/20/06 22:02:03 x25CircuitDown - Clear 2
PNE039 11/20/06 22:01:19 x25CircuitDown - Critical 1
PNE039 11/20/06 22:03:03 x25CircuitDown - Clear 2
PNE040 11/01/06 9:02:24 x25CircuitDown - Clear 2
PNE040 11/01/06 9:06:32 x25CircuitDown - Critical 1
PNE040 11/01/06 9:07:23 x25CircuitDown - Clear 2

Sites and Date are Sorted Ascending.
Num Field should follow 1,2,1,2 etc unless there is a problem.
I want to show just the ones that don't follow the above pattern.
So just show
PNE040 11/01/06 9:02:24 x25CircuitDown - Clear 2

Thank you, your help is apprecitated!!
 
Top