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

S

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
 
R

Rick Brandt

ship said:
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...
Click to expand...

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).
 
T

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
 
Top