Remove Duplicate Entries in Query Design

[samanthaM]

I am attempting to filter the data in query design such that it will not return anyone in the database has there name present more than one time.

For example, in the image below under the Owner_Name field there is "Abbot, Mark C Etux Wanda C". This name appears twice in the database. My criteria is the name can only appear once, therefore this record would not be returned after the query. In query design I would like it to return only name records that appear once in the entire database if there is a way to structure that.

Thank you very much in advanced

[June7]

Review: https://www.accessforums.net/queries...ion-38894.html