Stopping duplication in a query help

[snakeeyes]

I am using access 2007
and want to filter a name ie

joe bloggs 6 toffee lane picture
joe bloggs 6 toffee lane tree
joe bloggs 6 toffee lane dog
joe bloggs 6 toffee lane homecar

When i enter a query for joe bloggs 6 toffee lane i would like him to appear only once
instead of 4 times
how do i do this?
thanks paul

 

[Rabbie]

Look up DISTINCT in Access help

 

[snakeeyes]

i waas told how to do this with the unique record feature

for acess 2003 but ive forgotten how to do this and we have now upgraded to access 2007 and everything has now changed - bugger

I am building a query using design view from a table (the main database) .
help

The table will show

john hide ford
john hide vauxhall
John ford citroen
Paul Jones seat
paul jones bmw
paul jones mini

when i set the query up and it lists all the data i would like the name john hide and paul jones to appear only once and not 3 times in the query

 

[Thinh]

use a group by clause on first and last leave out the car model.
with a group by it should take care of duplicate

 

[Thinh]

i mean first and last name

 

[snakeeyes]

how do i group?

 

[snakeeyes]

Re: Stopping duplication in a query help actual senario

Lets start again with the actual senario
from the main table i would like to build a query that will list the following fields
Surname mr, Surname mrs, House number, street, postcode and investments type
ie evans evans 1 enfield road sr1 7yt pep
Mr and mrs evans have several investments so in the main table they have the following
mr evans 1 enfield road sr1 7yt pep
mr evans 1 enfield road sr1 7yt Bond
mr evans 1 enfield road sr1 7yt OEIC
mrs evans 1 enfield road sr1 7yt ISA
So in the query they will show up 4 times
i would like them to only show up once because they live at the same address in the query
is it also possible to arrange a query so that mr shows up once and mrs shows up once in the query ?