Hi, let me start with the table and sample data.
Fld1 Fld2 Fld3
False Group1 123
True Group1 123
False Group2 456
True Group2 456
False Group3 789
There is no PK. I can't change the structure of this table in any way, because it's linked via ODBC to a proprietary software. I am aware that this table's structure is lousy. The number of records, etc. changes dynamically because the proprietary software dumps records into it.
I need to eliminate the "false" records when a duplicate exists in Fld2 AND Fld3, but if a field is "false" and has no duplicate, then it must not be eliminated.
I have been going round and round with SQL subqueries and I can't get it done. Maybe some way using Design View in Access? Either way.