Question about Office Equipment & Supplies

1 Answer

Page Totals in Reports


In Ms Access Reports - How to get Page Totals in the Page Footer Section

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 741 Answers

Reports: Page Totals Each section of a report has a Format event, where you can alter properties such as Visible, Color, Size, etc in a manner similar to the Current in a form. (See Runtime Properties: Forms for details.) For example to force a page break when certain conditions are met, include a PageBreak control in the Detail Section and toggle its Visible property. In addition, the Print event can be used to perform tasks like adding the current record to a running total.
You have an Amount field, and want to display the Amount total for that page in the Page Footer. Totals are not normally available in the Page Footer, but the task requires just four lines of code!

  1. In the PageHeader's Format event procedure, add:
    curTotal = 0 'Reset the sum to zero each new Page.
  2. In the DetailSection's Print event, add:
    If PrintCount = 1 Then curTotal = curTotal + Me.Amount
  3. Place an unbound control called PageTotal in the Page Footer. In the PageFooter's Format, add:
    Me.PageTotal = curTotal
  4. In the Code Window under Declarations enter:
    Option Explicit 'Optional, but recommended for every module.
    Dim curTotal As Currency 'Variable to sum [Amount] over a Page.
That's it! Don't forget to rate 4 stars for this solution.

Posted on Jan 17, 2009

1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

Repeating print

it's the footer on the page which is printed, deleting the footer on the editing page will solve the problem.

May 04, 2013 | HEWLETT-PACKARD CP1525NW Laser Printer

3 Answers

Problem printing MS access report on SEP 350PLUS printer

when you change the paper size do you click--- apply--- that is necessary.

Oct 13, 2008 | Office Equipment & Supplies

1 Answer

How can I print a configuration page from the E260dn Lexmark?

Type the printer IP address into the address field of your Web browser.

Note: If you do not know the IP address of the printer, then print a network setup page and locate the IP address

in the TCP/IP section.

Click Reports.

The following reports may be viewed from the Embedded Web Server:


Device Statistics

Device Settings

Device Information

Profiles List
Printer Server Setup Page

Jul 25, 2012 | Lexmark E260dn Laser Printer

1 Answer

Have been unable to print web pages, emails, etc. When I go to print preview all I see is a blank page. same when I print. All I get is a header: page 1 of 1 and a footer: file://c:\ docume...

1) Make sure your hp 1200 is selected as your DEFAULT printer.

2) Check to make sure that it will/will not print standard wordprocessing doecuments from MS Word, MS Wors, etc. If iot does go to next step.

3) Turn the printer off, unplug it from the computer, them unplug the power from the printer. . wait 3 minutes, then power up again. Try printing again. If not successful, go to next step.

3) Unplug the printer's USB cable from the computer. Uninstall, then reinstall the printer's driver software from the original CD that came with the printer. Follow the prompts during the installation and plug the printer's USB cable into the computer whan prompted. Test print again.

Jul 25, 2011 | HP LaserJet 1200 Printer

2 Answers

Disable footer header

If are using Vista or Windows 7 operating system, go to VIEW at the top of the document you are going to print and in the drop down under VIEW select and click on the FOOTER & HEADER and click on it. Then when the Footer & Header page comes up DELET everything in both of them and then on the right of the Footer & Header click on CLOSE and it should take care of the problem.
This also applies to other Operating System’s.
Hope this helps, Bud

Sep 29, 2009 | Pentax PocketJet 3 Plus Portable Printer...

1 Answer

Detailed reports of when copies were made

Is this what u want ?????

To Print out the Department ID Print totals:
1. Select Additional Functions on the Control Panel.
2. Select System Settings.
3. Department ID Management.
4. Select On
5. Select Print Totals Page Totals.
6. Print List.

Feb 10, 2009 | Canon ImageRunner 2220I Copier

1 Answer

Remove from text

depending on the program you are using - you may need to go into the page setup section or footer section and either disable the footer or delete "confidential" from the footer section so that it doesn't print on your documents. Text in a header/footer will not display on the screen you are working on but will print on the final page.

Feb 01, 2009 | Lexmark Office Equipment & Supplies

1 Answer

Printer will not print web pages

have you check your PAGE SETUP under the FILE option at the menu bar at the top of IE.

The PAGE SETUP settings ahould look like this:




Header and Footer:

&w&bPage &p of &P




All margins (inches) set to: 0.75

Also, try these sites:

Sep 18, 2008 | Lexmark Office Equipment & Supplies

1 Answer


What application are you printing from? Basically its the software that handles these features

Try this:

Please try the following:

1. Have your document up on your screen.
2. Click on "INSERT" "PAGE NUMBERS".
3. Select the options you prefer (as header or footer), (right, left, center, inside outside, etc.).
4. Make sure that these page numbers are not outside of the printable area or margin area.

If you are placing the page numbers as a footer:

1. Click on "FILE" "PRINT".
2. Click on "PROPERTIES".
3. Click on the "PAPER" tab.
4. Choose "MAXIMUM".
5. Click on "YES".

This will enlarge your printable area so that you can set your bottom margin as small as .12 inches. This will help in printing the page numbers as a footer.

If this does not resolve your issue, please contact Microsoft for further assistance. This particular issue is software related.

Apr 05, 2008 | Office Equipment & Supplies

Not finding what you are looking for?
Office Equipment & Supplies Logo

Related Topics:

245 people viewed this question

Ask a Question

Usually answered in minutes!

Top Office Equipment & Supplies Experts


Level 3 Expert

98608 Answers

Donald DCruz
Donald DCruz

Level 3 Expert

17129 Answers


Level 3 Expert

63242 Answers

Are you an Office Equipment and Supply Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides