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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query Won't Run 0
Run query in another database 3
Use In() Expression as Query criteria with guts from Function 1
Combine Duplicates in Query 0
Access Access Report Works on One Machine but not Another 3
Entering criteria from form 2
text - code problem - query not returning full results 2
Running Sum in query 1

Back
Top