remove duplicates with conditional criteria

[sfgiantsdude]

Hi,



I am trying to design a delete query that has an additional criteria needed.

I want to delete identical IDs in one column only if there are identical values in an adjacent column.

So for example, in the table below I want to delete the last row where the duplicate ID is "2700023" because the Code field has identical values, "LRAC". I do not want to delete the second row because the Code field is different for the row.

ID Code
2699974 BCC
2699974 SRAC
2700023 LRAC
2700023 LRAC

Any suggestions? Thanks!

[June7]

Review:

http://www.techrepublic.com/article/...-access-query/

http://answers.microsoft.com/en-us/o...4-852b4435f12e