displaying list results horizontally?

[jatfill]

has anyone done this?
I have a table that tracks a set of codes for each user, users can 1+ codes each. I can pull the code list from a query, but is there a way to get that information (the query results) to display on a single line in a report like this:

Code1 Code2 Code3 Code4 Code5 Code6

Thanks!

 

[KevinM]

Use the CrossTab Query Wizard or Pivot Form Wizard.

HTH