List Names 7 rows by 3 cols

[sxschech]

I am trying to display a list of names in 7 rows and 3 cols as follows in a sample report shown below (Row # and Col #s would not be displayed on actual report, only here for illust purposes in case alignment doesn't work well):

-------------------------------------
Conference Distribution List

On 18 July these partcipants will be attending the conference:

(Col 1) (Col 2) (Col 3)
Row 1 Alberts, John Cooke, Mark Plange, Joe
Row 2 Beld, Fred Gorn, Dave ..
.. .. ..
.. .. ..
.. .. ..
.. .. Telman, Kris
Row 7 Chilfrum, Eric Openheimer, Bill Union, Michael


Conference room 114 Meeting Time 10:45 am


Attendees, please reply to xyz@email.com by 9:00 am for confirmation. Thank you.


--------------------------------------------------------


I tried using file page setup and changing cols from one to three, but didn't work as I would like since it seems to need to go to the end of the page before going to the next col. I was eventually able to get it to work as a subreport on another report, except I had to set the can grow property to no. When set to yes, it doesn't display in 3 cols. Problem would be that if in the future, there are more names than what I allocated, they won't show the additional names without going into design view and adjusting the size of the subreport. Any ideas would be greatly appreciated.

 

[CosmoKramer]

When defining your columns, you could set their layout also. In the Columns tab of Page Setup, change the Column Layout to Across, then Down




A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
Douglas Adams

 

[sxschech]

Thanks for the quick reply. Sorry if I didn't mention in original email that I set it up down and across because the request was to order the names down and then over as in the example. If I were to do as suggested, Across and then Down, any idea how to have the names sort alphabetically down the page per the example?

 

[jdegeorge]

This is a link I found to do something similar. Maybe you can play with it to get your desired results.

http://www.tek-tips.com/faqs.cfm?spid=701&sfid=3499

Hope this helps.




Jim DeGeorge

 

[jdegeorge]

This is a link I found to do something similar. Maybe you can play with it to get your desired results.

http://www.tek-tips.com/faqs.cfm?spid=701&sfid=3499

Hope this helps.




Jim DeGeorge

 

[dhookom]

I have done this before by creating a calculated column in the query that returns a "column" number. The column number was something like (caution air code):
Col:Int((Select Count(*) from tblA A WHERE a.LastName<tblName.LastName)*3 / (Select Count(*) from tblA))
You want to get the first third to have a value of &quot;1&quot;, the next third &quot;2&quot;, and the final third &quot;3&quot;.

Then create a single subreport that gets copied three times in the detail section of the report. Add three text box with control sources =1, =2, =3 and set the link master to one of these for each subreport and the link child would be [Col].


Duane
MS Access MVP