I have some records in a field (Column A) that are duplicate. I want to not show the duplicate records if Column B is null.
For example, records 1-4 are the same person and column A has an email address. I want to not show the duplicate items in when column B is null. How can I do this in my access query?
Also, some Column B emails can already be unique, so if it unique, then show.