Running a query on same info

T

Tony

Does anyone know how to run a query on a field where the criteria is that
they have the same info in it? Example, I have a database where if the
person has the same first name I want them to show up in a report. Thanks
for any help!!
 
K

KARL DEWEY

Are you looking for a report of records where two people have the same first
and last names?
Use a total query with the following fields --
FIELD FirstName LastName LastName
TOTAL Group By Group By Count
CRITERIA >1
 
Top