Q: put report footer at the bottom before the page footer?

  • Thread starter Thread starter MarkD
  • Start date Start date
M

MarkD

Using Access 2000

The report footer is printed right at the end of the
report. But I'd like it so that it prints at the bottom of
the last page of the report, just above the page footer.
Is there a way that can be easily done?

Thanks,
-Mark
 
Using Access 2000

The report footer is printed right at the end of the
report. But I'd like it so that it prints at the bottom of
the last page of the report, just above the page footer.
Is there a way that can be easily done?

Thanks,
-Mark
Click to expand...

Just above the Page Footer? No!
However, you can print the report footer data in the Page Footer of
the final page. If that will work for you post back and I'll post the
coding needed, or search for it in
hhtp://www.groups.google.com
 
-----Original Message-----


Just above the Page Footer? No!
However, you can print the report footer data in the Page Footer of
the final page. If that will work for you post back and I'll post the
coding needed, or search for it in
hhtp://www.groups.google.com
Click to expand...
Hey Fred...

Darn, I have criteria in the report footer and it just
looks weird having the criteria right after the last
report item.

Anyway, having the report footer on the page footer of
only the last page wouldn't really work, but I'm
interested in your solution. My offhand guess is you look
at [page] vs. [pages] and make the text visible only if
they're equal? Is that the gist of the code?

-Mark
 
-----Original Message-----


Just above the Page Footer? No!
However, you can print the report footer data in the Page Footer of
the final page. If that will work for you post back and I'll post the
coding needed, or search for it in
hhtp://www.groups.google.com
Click to expand...
Hey Fred...

Darn, I have criteria in the report footer and it just
looks weird having the criteria right after the last
report item.

Anyway, having the report footer on the page footer of
only the last page wouldn't really work, but I'm
interested in your solution. My offhand guess is you look
at [page] vs. [pages] and make the text visible only if
they're equal? Is that the gist of the code?

-Mark
Click to expand...

Yup, after having controls in the Page footer that equal the value of
the controls in the report footer.
 
Forgot to say that in my first reply.

-Mark
-----Original Message-----
-----Original Message-----
On Wed, 25 Aug 2004 15:31:10 -0700, MarkD wrote:

Using Access 2000

The report footer is printed right at the end of the
report. But I'd like it so that it prints at the
Click to expand...
bottom
of
the last page of the report, just above the page footer.
Is there a way that can be easily done?

Thanks,
-Mark

Just above the Page Footer? No!
However, you can print the report footer data in the
Click to expand...
Page
Footer of
the final page. If that will work for you post back and I'll post the
coding needed, or search for it in
hhtp://www.groups.google.com
Click to expand...
Hey Fred...

Darn, I have criteria in the report footer and it just
looks weird having the criteria right after the last
report item.

Anyway, having the report footer on the page footer of
only the last page wouldn't really work, but I'm
interested in your solution. My offhand guess is you look
at [page] vs. [pages] and make the text visible only if
they're equal? Is that the gist of the code?

-Mark
Click to expand...

Yup, after having controls in the Page footer that equal the value of
the controls in the report footer.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top