Access to show duplicates in a row

Hello,

can someone help with the following please:

Table
==============
Codes ! Accounts !
==============

In the accounts column i have 100 codes, in column accounts i have the accounts that relate to each code. Some codes may have more then 1 account. So the code will show twice with to separate account numbers.

C A
321 466987
321 598654
321 156987

I want to be able to show each code and have the 3 accounts in a row.

C A1 A2 A3
321 466987 598654 156987

Hope you can help.

Thanks in advance!




MS ACCESS 2003