query on duplicates

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

Guest

I want to make a query to pull all people with fax numbers. I can do this
but I have duplicate fax numbers. Is there a way to only pull one fax number
not the duplicate ones? If so how would I do that? Thanks in advance.

Maggie
 
Are you saying that there are individuals with more than one fax number OR
that more than one person could be using the same fax number? Or, gulp, both?
 

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

Duplicate showing in query when there shouldn't be 10
Deleting all duplicates 1
Access Auto Matching Duplicates? 0
Unique values in two fields in query 1
query 2
MTA Query Help 1
Populate 'To' recipient on custom mail form 0
Importing with "do not import duplicate items" based on 1 criterio 4

Back
Top