Is it possible to have a Footer at a fixed position on page

[inspiraller]

Hello

I have a page background image in my access report.
On top of the page I have the following

14cm - PAGE HEADER
DETAIL (containing a list of jobs)
INVOICE NUMBER FOOTER (containing a sum value of all jobs in DETAIL)
7.4cm - PAGE FOOTER

I want the DETAIL to begin at a fixed position on the page. My current method of doing this is to just expand the PAGE HEADER. This is ok.

I want the DETAIL to stop when its height reaches about 5 cm and force a new page when it does so. My current method of doing this is just to expand the PAGE FOOTER. this seems to work ok in a kind of implicit way. Would be nice to set a maximum height for the DETAILS so it doesnt grow beyond but I dont know how to do it.

In any case, the above works.

The main problem I am having is that the INVOICE NUMBER FOOTER displays itself straight after the DETAIL, which means its never going to be at an exact position on the page. I dont know where else to put it, because if i put it in the PAGE FOOTER, it causes an error.

My question is - Can I put the sum value of all jobs at a fixed position on the page?

I would appreciate any help.

 

[Crowley16]

Ok...

you'd have to put the sun in the page footer...

what is the error, and what are you putting in the control?

--------------------
Procrastinate Now!

 

[Crowley16]

Ok...

you'd have to put the sum in the page footer...

what is the error, and what are you putting in the control?

--------------------
Procrastinate Now!

 

[inspiraller]

Hi Crowley

Thanks for your reply

If I put the SUM VALUE of income into the PAGE FOOTER The printed error message just says #Error. In the TEXT BOX of CONTROL SOURCE I HAVE =Sum([Income]) which works in INVOICE FOOTER. This was originally created with the wizard.

So what can you recommend to put into the CONTROL SOURCE if I put this in the PAGE FOOTER?