Was wandering what the simple sql statement/setting is to select records from Access and if there was a field with the same value as another it would not select it.
So if your list was AABBCDDD what you select is only ABCD

Thanks for the help!