Transpose Rows and columns

[DrKeith]

Hi,
I would like to have a form with a datasheet view but would like to transpose the rows/columns. I need the variables to be on the y axis and enter data down each column (date for example).

Is there a way to do this? There is a microsoft KB to display a transposed table, but I need data to be entered into a form in this way. KB article

Thanks.

 

[jordanking]

the only thing I can think of is to creat a second table, transpose the rows progammically into the second table, and then use code to push the updates back to the main table if needed.

If all you need to do is display an uneditable snapshot of the data, then you can accomplish that with sub-queries and binding the recordset to the form/report upon opening. IF this is the case, post your data structure and what you have tried.

.....
I'd rather be surfing

 

[TheAceMan1]

How are ya DrKeith . . .

In the forms window, have you tried the [blue]PivotTable Wizard?[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[jordanking]

right, forgot about that totally.
probably best to use aceman's suggestion.

.....
I'd rather be surfing

 

[DrKeith]

I tried the pivottable, but I can't have the user enter data, only view it.

Thanks for the suggestions.

 

[jordanking]

I have not worked with pivot tables so hopefully aceman can tell you if they can contain updatable data (my feeling is no).

If you need it to be updatable, then you will have to have a second table.
What exactly do you want the user to update?
Do you want these updates to reflect back on the primary table?
What is your data structure?

.....
I'd rather be surfing