Select Distinct

[Van T. Dinh]

Do you have 1 Table that has both Member personal data and
Address data?

If this is the case, it is very hard to find Members that
live at the same Address since people enters Address data
differently. For example, the same address can be entered
as:

123 First Street

or

123 First St.

or

123 First St

and Access won't be able to recognise these as the same
address.

Perhaps, you need to re-structure your Database to have a
Table for Members(personal data without address details),
a Table for Addresses (just address details) and then you
link them. Even linking the above Tables, you need to
consider whether you want to set it as One (Address)-to-
Many (Members) or (depending on your use) Many (Addresses)-
to-Many (Members).

Check Access Help / Access books on One-to-Many
relationship and Many-to-Many relationship.

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I have probably what might seem like a very simple

question, but I have not been able to figure out how to do
it.

I have a database that has names and addresses of members

of a club I belong to. We send out a monthly newsletter.
Some of the members live at the same address. I was able
to "write" a macro using Select Distinct to return only
distinct addresses. However, I need the rest of the
information too (ie, name, city, state & zip code). How
do I "combine" macros to get all the information I need.