Merge different rows to same column in Access

[Micky]

I've looked everywhere to find out how to do this but I couldn't
figure it out. I need to take a table and where the TG_ID is the same
but has different NPA and update ALL_NPA to look like that at the
bottom and where it only returns one line per TG_ID with all the
NPA's in ALL_NPA on the same line.

Query3
TG_ID NPA
13579 303
13579 720
13581 303
13581 720

TO

Query3
TG_ID ALL_NPA
13579 303, 720
13581 303, 720




Thanks

 

[Duane Hookom]

Look here for the generic concatenate function:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[Micky]

Thanks Duane,

this is the query I use based on your example
ALL_NPA: Concatenate("SELECT NPA FROM TG_NPA WHERE TG_ID =" & [TG_ID])

And I get this error message:

Undefined function 'Concatenate' in expression.

any ideas why...I can't figure out what I'm doing wrong for the life of
me....

Micky

 

[Micky]

ok, I found another one of your postings Duane which explained the
error message and the fix which works great!!!! thanks.