The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

Re: [OT] Access Database Question



Would it be too much stress to create a Household table and then link
that
to each member?  A bit of one-off work up front.

;oj




On 10/08/2008, Paul Gordon <paul@xxxxxxx> wrote:
>
>   Snip
>
> 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?
> .
>
>
>


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


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


UKHA_D Main Index | UKHA_D Thread Index | UKHA_D Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.