[OT] Access Database Question

["Paul Gordon" <paul@xxxxxxxxxxxxxxxxxxxxx>]

Sorry for the OT, but I know there are a few Access gurus here,  -
because they've helped me in the past! - I have another question which
is *probably* fairly simple for you guys...



I run a database for a local residents association. It has a table of
members details. The details include the home address for every member,
and this is held stored as separate fields for:

Housenumber

Streetname

Postcode



Based on that table, I have query which uses an expression to provide me
with the address details concatenated, -  because that makes it easier
for the membership secretary to work with. The field expression is:
CompoundAddress: [Housenumber] & ", " & [Street] which is
fine, and
gives me a table with a column containing a nicely formatted address
like: "23, Acacia Avenue" - So far so good.



The next step I want to do is to generate a table that contains only
unique addresses; - since there are in many cases multiple members at
the same address. Since every individual has a member record, the query
above will include multiple records for some addresses. - I want to have
a table that only shows any given address once, so that I can produce a
list of households, rather than individuals...



Got any suggestions on where to start looking?



TIA



Paul G.



[Non-text portions of this message have been removed]


------------------------------------