If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report footer
I have a problem with my report footer, when the report consist of more than one page I dont get the footer to stay on the bottom of the page.
I have tried to use the page footer but then I get the text on every page not only the last one which I what. Anybody with a good tip on how to solve my problem?? |
#2
|
|||
|
|||
Report footer
You need to restrict the data so the report contains only the record(s) you
want. A simple way to do that is to use the OpenReport action in a macro, and use the WhereCondition to restrict the report. For example, if you only want the records where CategoryID is 12, put this for the WhereCondition (lower pane) in your macro: [CategoryID] = 12 Another alternative is to do this in the query, in the Criteria row. Naturally enough, the Report Footer section appears only at the end of the report, so the idea is to restrict the report to only the records you want. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "gorgas" wrote in message news I have a problem with my report footer, when the report consist of more than one page I dont get the footer to stay on the bottom of the page. I have tried to use the page footer but then I get the text on every page not only the last one which I what. Anybody with a good tip on how to solve my problem?? |
Thread Tools | |
Display Modes | |
|
|