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

  • Thread starter Thread starter ship
  • Start date Start date
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
 
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).
 
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
 
Back
Top