Is there any *quick* way to view data records *vertically* instead of as horizontal rows?

[ship]

Ms Access2003 / WindowsXP


Hi

Is there any quick way to view data with all fields of a record
arranged vertically (i.e. on top of each other) instead of
horizontally?

Obviously I could copy and paste into msExcell and transpose the whole
damned thing.
However this wont work for really large tables...

Ship
Shiperton Henethe

 

[Rick Brandt]

Ms Access2003 / WindowsXP


Hi

Is there any quick way to view data with all fields of a record
arranged vertically (i.e. on top of each other) instead of
horizontally?

Obviously I could copy and paste into msExcell and transpose the whole
damned thing.
However this wont work for really large tables...

A Crosstab query might do what you want, but your table would have to have
limited unique row values as you are limited to 255 columns (as is Excel prior
to 2007).

 

[Roger Carlson]

Create a form in Continuous View where all of the fields are stacked
vertically.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[tina]

select the table in the database window and on the toolbar click the "New
Object: AutoForm" button. the wizard automatically creates a form exactly as
you described.

hth