Rows As Colums On A Report

[Kriis]

Without using a cross-tab query, is there anyway I can display the rows as columns on a report...ie printing them horizontally, instead of vertically?

Thanks.

 

[Smart]

If I understand the problem your fields are as below

Field1
field2
field3
and you want them as

field1 field2 field3

if i'm right just click on field2 and drag it alongside field1 whe all done select all fields then chose format align top from the menu to align all the fields

Apologies if I have misunderstood

 

[Kriis]

Actually if I have a table like this:

WORKER
Name
Age

Instead of my report looking like this:

Age.............Name
1................Bob
2................John
3................Dave

I want it to look like this:

..............................Age
.................1.............2...............3
Name.........Bob.........John...........Dave

Is that possible (without doing a cross-tab query)?

 

[Rich]

Why don't you want to use a crosstab query ?

 

[Kriis]

Why don't you want to use a crosstab query ?

Because I'll then need to hardcode the column names. I don't want to have to do that because they will be changed.