Columns and layout problems

[Phil]

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

 

[Jeff Boyce]

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".

 

[Phil]

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

 

[Phil]

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

 

[Rick Brandt]

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.