Customized Distribution List on Cover Page

[sxschech]

Report pulls names and titles from a query displaying down page as such with text box paragraphs on lower third of report.

[tt]
---------------------------------------------------------
Date: 07-AUG-2011

To: Name1 President, Office No
Name2 Vice President, Office No
Name3 Associate VP, Finance, Office No
Name4 Associate VP, Information Technology, Office No
Name5 Associate VP, Development, Office No
Name6 Director, etc.....

From: SenderName

Re: This is the report as of Date.....

Definitions:

a - Active Employees
b - Morning Shift Employees
c - Afternoon Shift Employees
---------------------------------------------------------
[/tt]

The list of names has grown too long to fit on a page and supervisor suggested showing Names and Titles Across grouped by Title. One group of titles contains 12 people, so it would probably have to wrap 3 times (assuming could fit 4 across). I tried looking at label templates (Access 2010), but whenever I tried to edit the format, the information reverted from displaying across to displaying down the page.

Sample Layout for across the page:

[tt]
---------------------------------------------------------

Date: 07-AUG-2011

To: President Name1
Office No

Vice President Name2
Office No

Associate VP Name3 Name4 Name5
OfficeNo OfficeNo OfficeNo


Director Name6 Name7 Name8 Name9
OfficeNo OfficeNo OfficeNo OfficeNo

Name10 Name11 Name12 Name13
OfficeNo OfficeNo OfficeNo OfficeNo

Name14 Name15 Name16 Name17
OfficeNo OfficeNo OfficeNo OfficeNo



From: SenderName

Re: This is the report as of Date.....

Definitions:

a - Active Employees
b - Morning Shift Employees
c - Afternoon Shift Employees
---------------------------------------------------------
[/tt]


Table set up like:
SortOrder :number
Requestor :text
Title :text
OfficeNo :text

 

[genomon]

Have you experimented with the Columns tab in the Page Setup dialog box? You could probably use it on a subreport which you could add to the main report.

Gluais faicilleach le cupan làn

 

[sxschech]

Yes, I started by changing the number of columns in the columns tab, but I couldn't seem to get it to "wrap" during preview or printing, it stayed single col, perhaps there is another height setting I've missed that would get the data to show up in the other cols. As I mentioned I also tried the wizard which created the multi col, but because I needed to alter the text box, the instant I changed what was in the textbox, the multicol effect disapeared, even if I did an undo command. On the subreport, I also tried different sizings, and had removed the header/footer. Perhaps I'm overlooking something obvious?