Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying data in columnar format

Status
Not open for further replies.

tharlow

IS-IT--Management
May 22, 2003
1
US
I have a table of data structured as follows
field1 field2 field3 field4 tom1 tom2 tom3 tom4
.5 0 .65 .72 .7 .8 9 1.1

I want the display to be like

Field Tom
1 .5 .7
2 0 .8
3 .65 9
4 .72 1.1

Is there a simple formatting tool to do this? I have tried crosstab and Mailing labels but to no avail. The data is in the table exactly as listed above. tom* and field* are in the same field
 
Creata a standard report, right click the details section and select insert section below 3 times.

In the details A place Field1 Tom1
In the details B place Field2 Tom2
etc...

That should provide what you ask for.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top