Subform upside down

[Andy74]

I would like to have a subform (in datasheetview) to appear as "upside down", i.e. with row headings being the field names and the columns the different records. I don't know if there is a way to do it.

The reason is simply "aesthetic": the users of this would just store calculations which are normally made on excel spreadsheet and they appear in this way.

 

[Minty]

You can use a cross-tab query and display it, for display only purposes but it won't be editable.

 

[Andy74]

You can use a cross-tab query and display it, for display only purposes but it won't be editable.

thanks, but it really needs to be editable (on the non-calculated fields)

 

[Minty]

Slightly more difficult then, you would need to create a temp table on the fly, present that in the desired layout, then come up with some way of updating those records back to the source table.

Can't you explain it's not a spreadsheet

 

[sxschech]

Could you have two forms one sized only to display the headers and the other form above that and set to not display the headers? Or might have to try a continuous form with text boxes rather than a datasheet and use the footer rather than the header?