Finding duplicate records

[andressp]

Hi all,
I have a table like this

Name - Text
---------------------
Adams - text1
James - text2
Adams - text3
Steward - text4

And I want to converted to a table-query like this

Name - Text
---------------------
Adams - text1 & text3
James - text2
Steward – text4

The problem is that I have to do with text not with numbers
Is it possible?

Thanks for your time


Andreas

 

[CJ_London]

you could possibly to it using a crosstab - change the sum to first for the value column, but you need an additional column to specify column headings, not sure what that would be

so suggest look at using the concatrelated function http://allenbrowne.com/func-concat.html

 

[Ranman256]

Use the query wizard and make a Crosstab query.
Once built, modify the query and change the field where it usu says Sum, and change it to First.

But if you want to find duplicates, use the wizard and build a Find Duplicates query.