>I have a table which has three fields in which the data can be duplicated(keeps detail records with unique record numbers) ....I have records with the first two fields matching and the third not. What kind of select statement can I write to find these records and correct them?
Hi Steven,
Use code like this:
Select ;
Field1, Field2, Count(Distinct Field3) ;
From Table ;
Group By Field1, Field2 ;
Having Count(Distinct Field3) > 1
After that I'd set a relation from the result into the table, step through it, and correct/delete whatever you want.