Running a query on same info

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony - 04 Nov 2005 17:03 GMT

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

Reply to this Message

KARL DEWEY - 04 Nov 2005 18:08 GMT

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

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

Reply to this Message