If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple column report help
I want to make a multiple column report. I have a table where each record
contains 20 fields. I want to display the records in a report with each record in one column, having 6 records per page. I have been able to get this part set up, but now I want to have labels on the left side of the page (that only print once per page) that identify the name of each field. Can anyone help me please? TIA |
#2
|
|||
|
|||
Check this MS KB article
http://support.microsoft.com/default...44&Product=acc. -- Duane Hookom MS Access MVP "Suzie" wrote in message ... I want to make a multiple column report. I have a table where each record contains 20 fields. I want to display the records in a report with each record in one column, having 6 records per page. I have been able to get this part set up, but now I want to have labels on the left side of the page (that only print once per page) that identify the name of each field. Can anyone help me please? TIA |
#3
|
|||
|
|||
Thank you very much!
"Duane Hookom" wrote: Check this MS KB article http://support.microsoft.com/default...44&Product=acc. -- Duane Hookom MS Access MVP "Suzie" wrote in message ... I want to make a multiple column report. I have a table where each record contains 20 fields. I want to display the records in a report with each record in one column, having 6 records per page. I have been able to get this part set up, but now I want to have labels on the left side of the page (that only print once per page) that identify the name of each field. Can anyone help me please? TIA |
#4
|
|||
|
|||
I have the report set up, the MS KB article you referenced gave me exactly
what I needed. Now I would like to print a report title with the company name and date at the top of the report, centered on the page. Is this possible? TIA "Duane Hookom" wrote: Check this MS KB article http://support.microsoft.com/default...44&Product=acc. -- Duane Hookom MS Access MVP "Suzie" wrote in message ... I want to make a multiple column report. I have a table where each record contains 20 fields. I want to display the records in a report with each record in one column, having 6 records per page. I have been able to get this part set up, but now I want to have labels on the left side of the page (that only print once per page) that identify the name of each field. Can anyone help me please? TIA |
#5
|
|||
|
|||
I don't see why it wouldn't be possible. What did you try?
-- Duane Hookom MS Access MVP "Suzie" wrote in message ... I have the report set up, the MS KB article you referenced gave me exactly what I needed. Now I would like to print a report title with the company name and date at the top of the report, centered on the page. Is this possible? TIA "Duane Hookom" wrote: Check this MS KB article http://support.microsoft.com/default...44&Product=acc. -- Duane Hookom MS Access MVP "Suzie" wrote in message ... I want to make a multiple column report. I have a table where each record contains 20 fields. I want to display the records in a report with each record in one column, having 6 records per page. I have been able to get this part set up, but now I want to have labels on the left side of the page (that only print once per page) that identify the name of each field. Can anyone help me please? TIA |
#6
|
|||
|
|||
In design view the report is only one inch wide, the width of the column.
When I print it out, I get seven columns of data on the page. I want the titles to be wider than one inch, and I would like them to be centered on the page. I have tried making the multiple column report into a subreport where I put the titles on the main report, but I can't get the columns to print out as seven on the page when I do that, I only get one column. "Duane Hookom" wrote: I don't see why it wouldn't be possible. What did you try? -- Duane Hookom MS Access MVP "Suzie" wrote in message ... I have the report set up, the MS KB article you referenced gave me exactly what I needed. Now I would like to print a report title with the company name and date at the top of the report, centered on the page. Is this possible? TIA "Duane Hookom" wrote: Check this MS KB article http://support.microsoft.com/default...44&Product=acc. -- Duane Hookom MS Access MVP "Suzie" wrote in message ... I want to make a multiple column report. I have a table where each record contains 20 fields. I want to display the records in a report with each record in one column, having 6 records per page. I have been able to get this part set up, but now I want to have labels on the left side of the page (that only print once per page) that identify the name of each field. Can anyone help me please? TIA |
#7
|
|||
|
|||
Suzie wrote:
In design view the report is only one inch wide, the width of the column. When I print it out, I get seven columns of data on the page. I want the titles to be wider than one inch, and I would like them to be centered on the page. I have tried making the multiple column report into a subreport where I put the titles on the main report, but I can't get the columns to print out as seven on the page when I do that, I only get one column. If you go to Page Setup you can change the column settings so that they do not need to be the same width as the report sections as viewed in design view. This allows you to have a Report Header/Footer and/or a Page Header/Footer that is wider than your columns. However; those are the only sections that will ignore the column width setting. You can't for instance have columns that are 1 inch wide and a Group Header that is wider. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#8
|
|||
|
|||
I used code from the KB article Duane Hookom referenced to get the column of
labels to print on the left side of the report, so the actual width of the report has to be equal to the width of the text boxes in the column. I was hoping there was a way to put the titles up in the header, and then use vb code to move them to the center of the page after the detail section has been formatted. "Rick Brandt" wrote: Suzie wrote: In design view the report is only one inch wide, the width of the column. When I print it out, I get seven columns of data on the page. I want the titles to be wider than one inch, and I would like them to be centered on the page. I have tried making the multiple column report into a subreport where I put the titles on the main report, but I can't get the columns to print out as seven on the page when I do that, I only get one column. If you go to Page Setup you can change the column settings so that they do not need to be the same width as the report sections as viewed in design view. This allows you to have a Report Header/Footer and/or a Page Header/Footer that is wider than your columns. However; those are the only sections that will ignore the column width setting. You can't for instance have columns that are 1 inch wide and a Group Header that is wider. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#9
|
|||
|
|||
Multiple column report help
I have been searching the discussion group for this same problem. I have used
the code from the KB article that Duane referenced and now have a report that is setup with a column width of 2". I seem a bit confused, I am trying to have a report header that is across the whole page but no matter what I do with the column width in the page setup dialog I cannot get the correct format. If I set up 4 columns 2" wide with the "same as detail" unchecked and then have a header centered on the page (Letter in landscape) I end up with 4 columns of labels not the text info from my query. If I do not use a header and have the report width at 2" I get one column of labels and then 3 columns of data as I need. Am I missing something here is there really a way to have the report header wider than the detail section or does the bit of code that I have used from the KB article not allow me to use a header that is more than the width of the columns. Thanks in advance Steve "Suzie" wrote: I used code from the KB article Duane Hookom referenced to get the column of labels to print on the left side of the report, so the actual width of the report has to be equal to the width of the text boxes in the column. I was hoping there was a way to put the titles up in the header, and then use vb code to move them to the center of the page after the detail section has been formatted. "Rick Brandt" wrote: Suzie wrote: In design view the report is only one inch wide, the width of the column. When I print it out, I get seven columns of data on the page. I want the titles to be wider than one inch, and I would like them to be centered on the page. I have tried making the multiple column report into a subreport where I put the titles on the main report, but I can't get the columns to print out as seven on the page when I do that, I only get one column. If you go to Page Setup you can change the column settings so that they do not need to be the same width as the report sections as viewed in design view. This allows you to have a Report Header/Footer and/or a Page Header/Footer that is wider than your columns. However; those are the only sections that will ignore the column width setting. You can't for instance have columns that are 1 inch wide and a Group Header that is wider. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Column E cell contents added into Column D contents (not overwriting data but mixing) | creativetechguy | General Discussion | 2 | August 5th, 2004 07:32 PM |
I need to pull a report that uses multiple column information | Tracey Powell | Setting Up & Running Reports | 2 | July 14th, 2004 07:54 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
show multiple occuring name in a column | gr8guy | Worksheet Functions | 2 | January 14th, 2004 10:25 AM |