create query to select only 1 member of a household based on address

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

I have a mailing list in Access. I may have more than
one customer that live at the same address. It would be
adequate for me just to mail my information to one of the
customers. Is there a way to query for one record only,
when there are duplicate addresses?

Thanks!
Janet
 
I have a mailing list in Access. I may have more than
one customer that live at the same address. It would be
adequate for me just to mail my information to one of the
customers. Is there a way to query for one record only,
when there are duplicate addresses?

Thanks!
Janet
Click to expand...

If you can create a query with only fields from the Address table, you
can set its Unique Values property to True.

If you need to include the customer name from the customer table,
you'll need some way of deciding *which* customer's name should
appear. If it doesn't matter, you can create a Totals query; Group By
the address-table fields and select First() to pick an arbitrary name
from the customer table.
 
Back
Top