Hey, I just started migrating my excel spreadsheet into Access 2016 and I ran into a problem. I want to delete every customer entry besides for the completely unique ones.
Ex.
123 K Ave Susy Green 123 K Ave Susy Green 123 K Ave Susy Blue 123 K Ave Fred Blue 234 L Ave Fred Blue 234 L Ave Fred Green 234 L Ave Susy Green
I want to keep everything here since they are unique data sets except for the second row because it is completely identical to the first row. I've been able to delete if the addresses are identical but how do I filter based on the rest of the criteria as well? I do not want to run multiply queries comparing every possible color and name manually either. I want to have it automatically compare and delete completely identical entries but leave the rest.
Thanks for the help!