RE: [OT] Access Database Question

["Paul Gordon" <paul@xxxxxxxxxxxxxxxxxxxxx>]

HAHAHAHAHA!!!! - Access is such a sack of ****TE! - I can crash the
whole app by entering a select statement in my query...

-----Original Message-----
From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf
Of Rob Iles
Sent: 10 August 2008 15:24
To: UKHA Group
Subject: Re: [ukha_d] [OT] Access Database Question

http://www.fredosaurus.com/notes-db/select/distinct.html

I'm not overly familiar with access, but in SQL you'd use select
distinct -
- the above link seems to cover an MS Access scenario.

R.


2008/8/10 Paul Gordon <paul@xxxxxxx>

>   Hmm... not sure,
>
> Not sure a) how to do that, or, b) what the point of it would be...
> there are lots of values of potential household addresses, but only
ever
> a few member records to link to any given one... I'm not sure how
moving
> their address fields out to a separate table helps... - Although I'm
> willing to give it a try I guess...
>
> Strikes me that this should be *really* simple to do though, - there
> must be loads of cases where you only want to view unique values
within
> a table...
>
> Paul G.
>
>
> -----Original Message-----
> From: ukha_d@xxxxxxx <ukha_d%40yahoogroups.com> [mailto:
> ukha_d@xxxxxxx <ukha_d%40yahoogroups.com>] On Behalf
> Of Jon Whiten
> Sent: 10 August 2008 15:09
> To: UKHA Group
> Subject: Re: [ukha_d] [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<paul%40paulgordon.homeip.net>>
> 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]
>
> ------------------------------------
>
> **** Sponsored By http://www.Berble.com ****
> **** Computers You Carry ****
>
>
> 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
>
>



--


Rob Iles

RMIDevelopment

Web: http://www.rob-iles.co.uk/rmidevelopment
Twitter: http://twitter.com/Rob_Iles
Mobile: 079 6666 1092
Skype: rob_iles

[text rob followed by your message to 967482 from an orange phone in the
UK
*TESTING]


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


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