Display records as columns instead of rows

[Stryks]

Hi all. I think the answer to this question is going to be a flat 'No', but here we go.

I want to have something like a datasheet, except with with records shown as columns instead or rows.

For clarity, a datasheet displays records as rows, like this:

field 1 field 2
record 1 record 1
record 2 record 2

I'm wanting to present the data the other way around, like this:
field 1 record 1 record 2
field 2 record 1 record 2

Just to complicate matters, the number of records to be displayed is variable, so it should add more columns as required.

About the only option I can think of is to create a subform with fields stacked in a column without labels, and try to dynamically stack the forms as needed, hooking them up to the correct data on the fly.

Alternately, I wondered if I could dynamically generate a recordset with each record containing the field value of multiple records. I can see myself getting into trouble trying to update data this way however.

Any thoughts, or just a giant 'No'?

 

[MarkK]

Generally you want avoid converting columns into rows, but there are exceptions, notably the crosstab query, which does exactly that, and to good effect.

But what you are actually working on? If you present a more specific problem, someone might offer a more specific solution.