ok, and what I"ve been trying to explain is that i only have one column
defined in my report. There is ONE last name field. Access, in the
multi-column printing functionality automatically puts the second column on
the right side of the page. I don't "define" a second column. So let's say I
have 500 people in my directory. My detail section has a field called
LastName (and other things but we don't care about that right now). So it
prints each last name down the page. Lets's say it gets 50 on a page. If I
was using standard printing, it would fill up 10 pages, right? But since I'm
using column printing, instead of going to the next page, it actually puts
the 51st name at the top of the first page, but in wahat appears to be a
second column, even though i only have one column width of fields defined in
my report. So the first page will now contain 100 names (50 in both
columns). And of course the report will now be only 5 pages.
So, if I put a page footer in my report, it only prints once at the bottom
of a page. A group footer will print twice (under both columns), but it
still shows the PAGE number - the last page will have two page numbers, both
saying page 5.
What I'm not getting is where do I put the second text box you are referring
to?
.
I have been trying to explain that the page footer (not
group footer) needs a text box with my suggested expression
**for each column**.
If you have two columns, then the page footer needs two text
boxes, one on the left and another on the right.
Similarly for three columns using three text boxes.
Joseph said:
I don't worry about if each group fits on a single page - there is only
one
"group" - the list of names. I have a group header that breaks to a new
page
at each letter of the alphabet, but realistically it is all just one list
of
names.
So I have set up as one "column" of fields/data, and Access, using the
column printing feature, makes it into 2. If I put something in the page
footer, it only shows up under the first (left hand) column - my problem
is
getting something under the right hand column also.
Joseph Greenberg wrote:
I am using column printing from the page setup menu - my report is
defined
as 2 columns (for illustration sake, I am trying to print 2 pages of a
phone
directory on 1 8.5x14 piece of landscape (legal) paper. I have .5 inches
between columns and .25 inch margins so I each "page" in the report (and
the
available width of the report area) is 6.25".
I have my fields placed on the report, with appropriate grouping. That
is,
I
have ONE LastName field placed on the report. The column printing (down
first) takes care of creating the first column of names, and then goes
back
up to the top on the right hand column.
So....
There is only 1 "side" to my report - it's not like I've manally created
columns in the report. I have my report laid out, and I expect Access to
repeat it in columns - which it does. So if I were to have say 3 columns
defined on the page setup screen instead of 2, I'd want the bottom of
the
first column to say "Page 1", the bottom of the second column to say
"Page
2", and the bottom of the 3rd column say "Page 3" - even though they all
appear on the same physical piece of paper. The the first column on the
second physical piece of paper would say "Page 4", etc. If I place a
[Page]
in the group footer, I get the physical page number, same as if I placed
it
in the page footer.
The thing to keep in mind is that there is not real "grouping" at a high
level - all the last names are part of the same group. The other
grouping
variables I have defined are to take care of children records and
ordering,
and that sort of thing.
Does this now make any more sense?
Ok, you're using real report columns. I got that part, but
how do you guarantee the each group will fit in a single
column?
I still think you should use the page footer with a text box
positioned so that it appears under a column. Instead of
using just =Page, set each text box expression to reflect
the number of columns:
=3 * (Page - 1) + 1
=3 * (Page - 1) + 2
=3 * (Page - 1) + 3
