Compare data to itself within a column in Access?

[Guest]

I'm unable to crate a query that will compare the data in a colum with
"itself." I need to distinguish the records that have the same state and
city values but with different street values. This is to say, I'm looking to
return record one with State=Il, city=Chicago, Street=Michigan, record two
with the same state and city and Street=Ridge. If there are not more than
one street value for a matching state and city value I do not want those
values returned.

 

[Edward G]

In database window select the Query tab and click on the New button. From
the list select "Find Duplicates Query Wizard". Select the table you want to
query. Click Next. Select City and State. Click Next. Select Street Address.
Click Next. Click Finish.
Hope that helps.