Re: [OT] Access Database Question

[Stephen McGarry <Selfbuild@xxxxxxxxxxxxxxx>]

Paul
Very simple. Just open the query in design mode and select the query
properties (right click on blank bit between tables
at the top) and set the Unique Values line to YES ...
that's it...


HTH
Stephen

Paul Gordon wrote:
>
>
> 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]
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.138 / Virus Database: 270.6.0/1602 - Release Date:
09/08/2008 13:22
>


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