mihoy
05-17-2000, 12:12 PM
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.
Thank you for your help in advance.
|
View Full Version : Reports that display data vertically mihoy 05-17-2000, 12:12 PM 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. Pat Hartman 05-17-2000, 05:40 PM I'm not quite sure what you are looking for. The detail section can contain multiple print lines as it does for an address label. It's just a matter of how you arrange the fields - side by side or stacked. Or perhaps you are looking for something like a snaking list similar to what you would see in the telephone book. To do that, you would set the column property of the form. mihoy 05-18-2000, 09:00 AM 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. Pat Hartman 05-18-2000, 10:06 AM When you add a textbox control to a form, Access automatically creates a linked label control to the left of the textbox. You can select this label control and delete it if you prefer to use column labels rather than field labels. mihoy 05-19-2000, 12:40 PM 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? Pat Hartman 05-19-2000, 08:30 PM I guess I don't understand your question. Perhaps an example would help. mihoy 05-20-2000, 08:05 AM 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! Pat Hartman 05-20-2000, 01:56 PM I don't see any way to accomplish this. You would need a column property for the detail section so you could suppress the labels in any but column 1. However, I can't find one. |