Hi,
I am trying to create a query where I check whether a value from one column is in another and if so bring back no result. E.g:
ID Name1 Name2
1 Bob Bob
1 Bob Bill
1 Bob Dave
1 Bob Keith
2 Dave Bob
2 Dave Sam
2 Dave Bill
2 Dave Keith
For my rule ID1 is fine as Bob is in Name1 and Name2 (therefore this should pass), however ID2 would need to be highlighted as Dave is in Name1 but not in Name2 for that ID.
Any suggestions, should I even be doing this in Access?
Many thanks
I am trying to create a query where I check whether a value from one column is in another and if so bring back no result. E.g:
ID Name1 Name2
1 Bob Bob
1 Bob Bill
1 Bob Dave
1 Bob Keith
2 Dave Bob
2 Dave Sam
2 Dave Bill
2 Dave Keith
For my rule ID1 is fine as Bob is in Name1 and Name2 (therefore this should pass), however ID2 would need to be highlighted as Dave is in Name1 but not in Name2 for that ID.
Any suggestions, should I even be doing this in Access?
Many thanks