ok this is a hard query to do...please help 1

[snobrdinrtiste]

hey guys sorry for the cryptic subject header but....
i have a problem of trying to query a table that has
for example 3 records that has the same information for the name, address, phone, etc. fields
EXCEPT for the comment field

so the records will look like this:

john doe1 - new york - Italian
john doe1 - new york - Blue Eyes
john doe1 - new york - Yankees Fan

so how would i do a query that returns just:
john doe1 - new york - Italian,Blue Eyes,Yankees Fan

 

[johnherman]

see thread183-1201127

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[johnherman]

Oops thread183-1195268 or thread759-1033713

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[snobrdinrtiste]

hey john,
thanks for the help!
I couldn't search for it cuz i didn't really know how to call that kind of a query...
thanks!