Merging in the same table

[Guest]

Hi-

I have a table in which I have

URL - Text
Category - Text
Descrip - Memo

I would like to merge duplicate records where

URL = URL

Merging means

URL = URL
Category + ", " + Category
Descrip + <CR> + Descrip

Any recommedations on the best way to query to do this? I am assuming its a
group query but need some help.

Thanks!
Larry

 

[Duane Hookom]

My recommendation is to provide some sample records and how you would like
them to appear in your query. I expect the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane should
work.