Changing from Row into columns

[Twee]

Hi,

This is my first time posting so I hope I make sense. I have a table where
I need to change from row into one line column.

This is what I have:
Patient ID Code Code
A 123
A 456
A 789
A 147

Each patient could have varying number of codes. For instance, patient A
has four codes but patient B has 18 codes.

This is What I need: Everything in column instead, with room for up to 50
codes

Patient ID Code 1 Code 2 Code 3
Code 4
A 123 456 789
147

Can anyone please help me? I tried a crosstab query but it did not seem to
work...Any ideas will help me greatly. Thank you!!

 

[Peter Hibbs]

If you are trying to display the information on a form a Flex Grid
Control will do what you want but it will involve a fair bit of VBA
code. Have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex Grid Demo.mdb'

for some examples including one which does more or less what you want.

Peter Hibbs.