I have a 2 column database
The columns are Hedge_No and GID
here is what it looks like
Hedge_No.......GID
BF239.............CLU
BF239.............Swap
BF240.............CLS
BF240.............Swap
etc on down
What I want to do is build a query that will show me if a Hedge_No is missing either the CLU/CLS or Swap. There are hundreds of Hedge_No's with other GID's added, but the minimum criteria is that they must have either a CLS or CLU coupled with a Swap.
Any help would be greatly appreciated.
Thanks
Neil
The columns are Hedge_No and GID
here is what it looks like
Hedge_No.......GID
BF239.............CLU
BF239.............Swap
BF240.............CLS
BF240.............Swap
etc on down
What I want to do is build a query that will show me if a Hedge_No is missing either the CLU/CLS or Swap. There are hundreds of Hedge_No's with other GID's added, but the minimum criteria is that they must have either a CLS or CLU coupled with a Swap.
Any help would be greatly appreciated.
Thanks
Neil