Merge different rows to same column in Access

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

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

--
Duane Hookom
MS Access MVP
--

"Micky" wrote in message
ps.com...
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

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

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