Report Footers

[saintsman]

I am designing a report where I want to print something attached to the last record on each page (a signature block). The problem is that it must be attached to the last record (not always in the same place on the paper) and I can do this by using a report footer. However that will only print on the last page and I need it on every page. What do I really need to do?

I hope that's clear, many thanks,

Saintsman

 

[Rich]

Use the page footer

 

[ColinEssex]

Presumably this isn't just going into the page footer?

Col


edit: Rich you just beat me to it

 

[saintsman]

No, the page footer puts the info at the bottom of the page. If my last entry is halfway up the page I need the signature box attached to it.

If I have records that take up two pages, I need a signature block on page 1 and another on page 2. For legal reasons (civil aviation) the signature block must emcompass the work carried out on each page and also be directly attached to the last record on each page. This is not such a problem in a word document because you can have blank entries to fill up the page. If my access report's last record is half way up the page then the rest of the page is blank until you get to the footer. That is why I can't use the footer for my signature block. A report footer solves this problem on the last page but not the first.

 

[Rich]

Group footer? or another textbox under the detail section

 

[saintsman]

Thanks for your input and sorry for not getting back earlier.

I think I may have solved it. I have used a page footer and a report footer with the Report Page Footer properties set to 'Not with Rpt Ftr'. It just needed some careful positioning to make sure that there was no gap between the last record and the page footer.