 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / June 2005Totals to stay in Fixed Position
I have a Totals line in the Report Total section that I want to print exactly 4 inches from the bottom of the page regardless of how many detail lines are present. Currently the position of the Totals line is dependent on how many detail lines are printed. I want the Totals to be at exactly the same place on the page every time. Any thoughts ? Put it in your Report footer or page footer and make your footer 4 inches tall with the totals near the top.  SignatureRick B > I have a Totals line in the Report Total section that I want to print > exactly 4 inches from the bottom of the page regardless of how many detail [quoted text clipped - 6 lines] > > Any thoughts ? Thanks Rick, Tried that, but the whole 4 inches moves up the page when only 1 detail line is present. I need some way to specify that the 4 inch Report Total section should start 7 inches from the Top of the page regardless of how large the detail section is... I think I have done this before, just forgot how I did it. Do you set the position in code using the On Format ? Rob > Put it in your Report footer or page footer and make your footer 4 inches > tall with the totals near the top. [quoted text clipped - 10 lines] >> >> Any thoughts ? > Thanks Rick, > [quoted text clipped - 8 lines] > > Rob Probably you put it in report non page footer >> Put it in your Report footer or page footer and make your footer 4 >> inches tall with the totals near the top. [quoted text clipped - 14 lines] >>> >>> Any thoughts ? Signature_ _ Ciao MAssimiliano Amendola www.accessgroup.it Cisa - Conferenza Italiana per Sviluppatori Access Info: www.donkarl.com/it Hi... I did put the Totals in the "Report Footer" - problem is that the Report Footer "floats" up and down the page depending on the size of the detail for that report. >> Thanks Rick, >> [quoted text clipped - 29 lines] >>>> >>>> Any thoughts ? Use the Page Footer! SignatureRick B > Hi... > [quoted text clipped - 35 lines] > >>>> > >>>> Any thoughts ? Hi Rick, Did that, looks like position will work OK, but now the formulas do no work i.e. =sum(Sales) gives an error message Thanks, Rob > Use the Page Footer! > [quoted text clipped - 38 lines] >> >>>> >> >>>> Any thoughts ? > Hi Rick, > [quoted text clipped - 46 lines] >>> >>>> >>> >>>> Any thoughts ? You should use the Page Footer, but you cannot use your expression in the page footer. See Microsoft Knowledgebase article 132017 "How to sum a column of numbers in a report by page" Use that method. SignatureFred Please only reply to this newsgroup. I do not reply to personal email. > Hi... > > I did put the Totals in the "Report Footer" - problem is that the > Report Footer "floats" up and down the page depending on the size of > the detail for that report. In fact you have to put in Page footer not report. Page keep you setting for all pages (and the same for Head), Report put it just bottom the body. Try to make a report of 2 pages and put a label in Page footer and anotherone in the report and it will be clear the difference >>> Thanks Rick, >>> [quoted text clipped - 36 lines] >> Cisa - Conferenza Italiana per Sviluppatori Access >> Info: www.donkarl.com/it Signature_ _ Ciao MAssimiliano Amendola www.accessgroup.it Cisa - Conferenza Italiana per Sviluppatori Access Info: www.donkarl.com/it |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.