Reports that display data vertically

[mihoy]

Hi, everyone. I was wondering if it was possible to create reports that display data vertically, instead of going across horizontally.
Thank you for your help in advance.

 

[mihoy]

Thanks, Pat for the reply. I did figure out that I can stack the fields vertically. But I couldn't figure out how to do the column headings (well, row headings in what I am trying to do) and have multiple columns of data displayed. I don't want the labels to be displayed for each columns. I hope I cleafied my question. Thank you for the help.

 

[mihoy]

That doesn't seem to work because it puts out the labels for every column regardless of the labels are attached to the text boxes or not. Is there any way to specify those labels to be output once?

 

[mihoy]

Ok, here is an example. Say I have a First Name, and Last Name as my fields. In Access Reports, I can create a report like this:

First Name Last Name
John Doe
Jane Smith
Jack Smith

What I am trying to do is to make is look like this:

First Name John Jane Jack
Last Name Doe Smith Smith

The closest I get with the labels is:

First Name John First Name Jane ..
Last Name Doe Last Name Smith ..

It repeats the row heading in the detail section when I do the multiple columns.

Thank you for help!