M
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
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