|
Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word? Home Page Bloglines 1906 CelebrateStadium 2006 OfficeZealot Scobleizer TechRepublic AskWoody SpyJournal Computers Software Microsoft Windows Excel FrontPage PowerPoint Outlook Word 
Host your Web site with PureHost! 
|
 
Friday, November 03, 2017 – Permalink – Total FooterSum() it upIf you would like to show a total in the footer or each page of a report, you may have a problem. Access does not allow the SUM() function in the footer. The way around this is to put a SUM() function in an unbound text box in another part of the report. Choose Properties and set the visible property of the control to No. In the footer, create another control using the "calculation" text box as the ControlSource. The Sum() function, as well as the other aggregate (totals) functions can reference only a field and not a control. From the Microsoft Knowledge base: How to Sum a Calculation in a Report How to Display and Total Subtotals from Subreports See all Topics access Labels: Customize, General, Reference, Shortcuts, Tips, Tutorials <Doug Klippert@ 3:12 AM
Comments:
Post a Comment
|
