How do I Concatenate Multiple rows in one row? Help

[mike_NY]

I'm new to Access, this is the sample table

IDCODE NAME
267 MIKE
267 JOHN
267 K
268 DEBBY
268 JAY
269 MARTHA
269 KENNEDY
269 G
269 JOY
269 V

i want to sort them in one row. the result shoul be
267 MIKE JOHN K
268 DEBBY JAY
269 MARTHA KENNEDY G JOY V


PLEASE HELP
THANKS

 

[Jason Lepack]

Weblink, watch for line breaks:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

This is Duane Hookom's Concatenate function.

Cheers,
Jason Lepack

 

[Guest]

Have a look at Duane Hookom's - Generic Fucntion to Concatenate Child
Records:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane