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...