Avatar of contrain
Flag for United States of America

asked on 

Finding a unique value in Access 2010 query

In Access 2010, I have a query based on a table that has fields for FName, LName, Company, and Email. Some of the records have the same FName, LName and Email. for these records, just focusing on the Email field, I want to create a query that will only give me a record where the email is unique, so I want to get rid of the records that have duplicate fields.

Microsoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon