[AccessD] Two Column Table Convert Rows To Columns

[Paul Hartland]

To all,

Having a bit of a brain freeze here and can't seem to find the answer in
google....I have a table with two columns Item_No, Branch_Code and I will
have data similar to below:

Item_No    Branch_Code
12345        ABC
12345        DTR
12345        GTH
23456        AAA
23456        AAB

and what I need is

Item_No      Branch_Code
12345          ABC, DTR, GTH
23456          AAA, AAB

Could someone please point me in the right direction, this sounds as if it
should be simple enough and I am 100% sure I have done this before....

MANY MANY thanks in advance for any help on this.



-- 
Paul Hartland
paul.hartland at googlemail.com