Change row and column positions

  • Thread starter Thread starter Alice
  • Start date Start date
A

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
 
I don't think you can do that, Access thinks top to
bottom, not left to right. :)
Could you just print it out landscape?
 
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:
Click to expand...

Create a report based on that query. Then you can arrange each row (record)
as you like.
 
I don't know if I did the same thing as you are
suggesting, but I did not get a table when I tried in
Report.

Instead, I got sth like

ID: 1
Name: Alice
Salary: 1000


ID: 2
Name: Peter
Salary:2000


ID:3
Name: Tom
Salary: 3000


What I want is a table like this:

ID: 1 2 3
Name: Alice Peter Tom
Salary:1000 2000 3000

Can you please tell me in specific how to do this? I am
really new to Reports.....

Appreciated...

Alice
 
What I want is a table like this:
ID: 1 2 3
Name: Alice Peter Tom
Salary:1000 2000 3000
Click to expand...

Oh, I guess I didn't really understand what you were asking for (high
density brain cells, I guess - I thought you were looking for multiple rows
per record). After a little searching around for Duanes response, I found
that he has responded with what would have been my next (and more
appropriate) suggestion.
 
Back
Top