Recent content by 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...

how do i group?

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

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