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
|
|||
|
|||
Columns and layout problems
Hi
I have a simple database which contains the telephone extension details of personnel on our two sites in the company. Users can then access this via our intranet for details when trying to contact someone. However, some people on either site have no access to a PC and need a printed out version sent to them. What I need to do is to be able to create a report or word document (using mail merge I'm thinking) that an admin person can print out and then send to the relevant people. The problem is I can't work out how to do the layout as required. What I need is the page to be in 3 columns (due to the number of people in the list) with the top half being members of one site, and the bottom half being members of another site, some thing like this: Site 1: Amble, Paul x123 Jeffs, Leah x368 Shore, Liz x875 Ashton. Mick x124 Johnson, Peter x 854 Scotte, Helen x369 Jones, Jason x375 Smith, Adam x859 Barry, Jane x547 Smith, Jackie x897 Bothe, Jason x537 Matthews, Jo x767 Tarr, Sue x578 Cawood, Matt x765 Price, Dave x537 Terries, Helen x986 Thompson, J x236 Gath, Katie x347 Rawson, Adam x347 Site 2: Amble, Paul x123 Jeffs, Leah x368 Shore, Liz x875 Ashton. Mick x124 Johnson, Peter x 854 Scotte, Helen x369 Jones, Jason x375 Smith, Adam x859 Barry, Jane x547 Smith, Jackie x897 Bothe, Jason x537 Matthews, Jo x767 Tarr, Sue x578 Cawood, Matt x765 Price, Dave x537 Terries, Helen x986 Thompson, J x236 Gath, Katie x347 Rawson, Adam x347 (Obviously with different names in site 2 - just couldn't be bothered writing new ones here!) Anyone got any ideas how this could be achieved? Would be ideally done as a report, however a word document with mail merge would be acceptable, though I don't seem to have had any success with either of these Any help, tips, ideas would be gratefully received Regards Phil |
#2
|
|||
|
|||
Phil
Have you looked into the File | Page Setup menu choice when you have the report open in design mode? There's a tab for Columns that lets you set # and spacing, and "snaking". -- Good luck Jeff Boyce Access MVP |
#3
|
|||
|
|||
Thanks for your reply, am pulling my hair out with this one.
Yeah I looked into that 2 problems though: 1) I can't work out how to have the 2 separate sites - so that it looks like the example in my first posting. 2) if I do the column layout to go "down then across" as required it seems to need to go all the way down to the bottom of the page instead of just making 3 equal length columns. Any ideas? Phil "Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message ... Phil Have you looked into the File | Page Setup menu choice when you have the report open in design mode? There's a tab for Columns that lets you set # and spacing, and "snaking". -- Good luck Jeff Boyce Access MVP |
#4
|
|||
|
|||
Just realised the example of how I wanted it to look in my first posting didn't come out right on here. Want it to look a bit like the following ********************* Name of Site 1 User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # User # Name of Site 2 User # User # User # User # User # User # User # User # User # User # User # User # User # User # ******************* Hope that makes more sense Phil |
#5
|
|||
|
|||
"Phil" anon@hotmail wrote in message
... Thanks for your reply, am pulling my hair out with this one. Yeah I looked into that 2 problems though: 1) I can't work out how to have the 2 separate sites - so that it looks like the example in my first posting. 2) if I do the column layout to go "down then across" as required it seems to need to go all the way down to the bottom of the page instead of just making 3 equal length columns. You have mutually exclusive goals. If you want the columns to be the same height then you can't use "Down, Then Across" columns. Unless you want to get complicated with multiple subreports positioned side by side or something similar. -- 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 |
Need immediate Help Please (reporting layout) | [email protected] | Setting Up & Running Reports | 1 | August 5th, 2004 06:59 PM |
Dynamic Report Data Columns | Jay | Setting Up & Running Reports | 3 | July 20th, 2004 09:45 PM |
distorted layout by email | [email protected] | General Discussion | 1 | July 2nd, 2004 06:29 PM |
Create new folders with the "outbound message folders" layout | dsl25 | Outlook Express | 3 | June 23rd, 2004 10:26 AM |
Problems with comparing data | Frank Kabel | Worksheet Functions | 4 | April 15th, 2004 06:40 PM |