Help data cleaning

[baronqueefington]

Hello,

I have a table that includes 2 fields which I need compared, the table looks like this:

case number ID Name
1 1 Bob
2 1 Bobby
3 2 John
4 1 Bobi
5 3 Mark

I need a query that checks to see if the ID and name are consistent. So in the above example ID's 2 and 3 are ignored but ID 1 will appear.

This is a hang over from imported spreadsheet data and will eventually be moved over to a lookup table, which should stop this from being an issue.

Thank you.

[June7]

Try:

SELECT DISTINCT *.T1 FROM TableName AS T1 INNER JOIN TableName AS T2 ON T1.ID = T2.ID WHERE T1.[Name] <> T2.[Name] ORDER BY T1.ID;