Query syntax question

[ksaab]

Is there a way in a query to only show a value that is duplicated across more than one record? Example: I have two columns Zip 1 and Zip 2 from two different tables. The tables are linked on city and state - I am trying to show a Zip overlay in a query. I need Zip1 to show only if it has duplicate values across records but not if it is displayed uniquely..

Is it friday yet?

 

[Štef1]

Hello Ksab!
On the Access window click on "Queries" tab,
then "New" button, on NewQuery window chose
"Find Duplicates Query Wizard", follow wizard.
Look at "DemoDuplicateA97.mdb"

 

[ksaab]

Thank you so much! I was able to get the same result this morning but without your syntax help it took me 5 more queries to get to the result!

Thanks again..

ksaab