I have an access table that consits of 21 fields. Of those 21 fields one field is an account number and another the state code, IL, NY etc. Due to a data glitch, some records are being duplicated except the state field. In essence there are two rows where 20 of the 21 fields are identical, and the state field is different for the rows.
I want to remove the duplicates based on a heirarchy of states that I have. So, since AZ is higher on my list than IL, I want to remove the IL entry and leave the AZ record.
How do I do this in the 'Design Query' interface rather than SQL?