'=' Query Problem

[sross]

I am trying to create a query with the following criteria and have no clue where to start.
fstnm=spname, lstnm=splstnm, add1, zip

 

[Drunkenneo]

Firstly what the output you required?

 

[sross]

I am trying to check for duplicates in a mailing list. I need to see these fields fstnm, lstnm, spfstnm, splstnm, add1, zip where fstnm=spfstnm, lstnm=splstnm.

Sorry if I am not as clear as you need me to be - I am totally new to this. Thx

 

[Drunkenneo]

This Will be a help

SELECT col1, col2, Count(col1) AS NumberOfDups
FROM [Add]
GROUP BY Add.[coll1], Add.[col2], Add.[col3]
HAVING (((Count(Add.[col1]))>1) AND ((Count(Add.[col2]))>1));

Owise there is a design wizard in Access which will help solve most of the general queries.