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

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
 
F

fredg

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

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
 
M

MarkD

-----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
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
 
F

fredg

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

Yup, after having controls in the Page footer that equal the value of
the controls in the report footer.
 
M

MarkD

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top