Change row and column positions

[Alice]

I have a query which returns about 30 fields, and I need
to print the result out as a table. But I cannot fit all
the 30 columns on one piece of paper. Therefore, i want to
change the columns into rows instead:

Before:

ID Name Salary Gender HomeAddress Phone ....field30
1
2
3
..
..
..

After:

ID: 1 2 3 4 5 6....
Name: Alex Peter Mary
Salary:
Gender:
HomeAddress:...
Phone:
....
Field30:

Can anyone please tell me how to accomplish this? I'm new
to report, and I don't know if Report is the solution for
this, or is there some other ways?

Thanks a lot,

Alice

 

[Heather]

Create a query first, using the crosstab Query Wizard, a
cross tab will flip the data for you. From the query,
create a report.

 

[Alice]

No, but the cross tab query only allows one "value" field.
But all my fields are "value"s.

Can you explain more about what I should do?

Thanks,

Alice