Running a query on same info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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
 
Back
Top