I tried this starting at the query level and haven't had lotsa luck. What I'm using now is a maketable qry which leaves me with a table containing duplicate records.
I'd like to filter out the records where ALL fields match any other record in the table. Like this:
F1 F2 F3 F4 F5*
a b c d 1
a b c d 1
a b c d 2
a a a a 2
What I want is ONLY the last two lines. I can use SQL (with very specific instruction), VBA (with suggestions to get me started), or any functionality in Access 2000.
I'd like to filter out the records where ALL fields match any other record in the table. Like this:
F1 F2 F3 F4 F5*
a b c d 1
a b c d 1
a b c d 2
a a a a 2
What I want is ONLY the last two lines. I can use SQL (with very specific instruction), VBA (with suggestions to get me started), or any functionality in Access 2000.