Re: [OT] Access Database Question

["Martyn Wendon" <martynwendon@xxxxxxxxxxx>]

Paul,

Did you manage this yet?

If not, then in design view of your query that concatenates the address
together, click the "Totals" icon on the toolbar (looks like a
funky capital
E).

By default that adds the "Total:" row in the query designer and
sets it to
"Group By" for all the columns, which should achieve what you
want (unique
addresses).

You can then change the query type to one that creates a table from the
query results if you need to.


Hope that helps!

Martyn

----- Original Message -----
From: "Paul Gordon" <paul@xxxxxxx>
To: "UKHA Group" <ukha_d@xxxxxxx>
Sent: Sunday, August 10, 2008 2:59 PM
Subject: [ukha_d] [OT] Access Database Question


> 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]
>
>
> ------------------------------------
>
> **** Sponsored By http://www.Berble.com ****
> ****       Computers You Carry          ****
>
>
>
>
>
>



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