Help with query to find confilicting info

[JamesDSM50328]

Hi I am needing some help trying to create a query that finds conflicting info in a table.
Fields are [rule],[name],[value],[oper].
The first 3 fields can contain the same info but but may not contain the same info. The oper field contains =,<>,>,<,IN,!IN I need to compare if there are matching records with the IN and !IN or = and <> and the rest of the row would contain equal data.

Needs to find this type of record.
Example
[Rule] [name] [Value] [oper]
4153 Mtg Prog Corp Relo 3% IN
4153 Mtg Prog Corp Relo 3% !IN
4156 Family NonConforming =
4156 Family NonConforming <>

 

[randy700]

Have you tried the built in Find Duplicate or Find Unmatched query wizards?


Randy