Question about Office Equipment & Supplies

1 Answer

Page Totals in Reports

Sir,

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

    All-Star:

    An expert that got 10 achievements.

    MVP:

    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

6ya6ya
  • 2 Answers

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

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to delete a header/footer in excel 2010?


To remove the header or footer text from Excel 2010 worksheet, you can follow the instructions below:
1.Go to "Insert" tab and then go to "Text" section.
2.Click "Header and Footer"
3.Click the left, center, or right header or footer text box at the top or the bottom of your worksheet page.
(Note: Clicking any text box selects the header or footer and displays the "Header and Footer Tools", adding the "Design" tab.)
4.Press "Backspace" or "Delete" on your keyboard.
To know more about removing header and footer, you can refer to "Remove the header or footer text from a worksheet" section on the following Microsoft support page:
http://office.microsoft.com/en-in/excel-help/use-headers-and-footers-in-worksheet-printouts-HP010342991.aspx#BMremoveheaderfootertext

Hope this will help you.

GuruAid.com

Sep 03, 2014 | Microsoft Computers & Internet

1 Answer

How do you Z out a 435dx


"Z" (Prints End-of-Day Management Reports and Resets Totals) - Prints the "Z" management report at the end-of-the-day and resets totals to zero (except "locked-in" grand total).
To print Management Reports, slide the control switch to the "X" or "Z" position as needed, then press the [amt tend/TOTAL] key. Refer to explanation starting on page 37.
"X" AND "Z" SALES MANAGEMENT REPORTS
__________________________________________________________________
Transaction data is maintained in the memory of the cash register as long as the battery back-up system is in effect. This data can be printed as a report for management review.
The Management Report can be printed from either the "X" or the "Z" position on the Control Switch.
"X" POSITION REPORT (Refers to a mid-day reading)
The "X" position report prints the accumulated information and RETAINS ALL TOTALS IN MEMORY. Use this position to print periodic readings of transaction information at any time through-out the day. (Some users call the X-report a mid-day report).
"Z" POSITION REPORT (Refers to an end-of-day or close-out reading)
The "Z" position report prints the same information as the "X" report. However, once this report is printed, ALL TRANSACTION TOTALS ARE RESET TO ZERO except the Grand Total. (Some users call the Z-report an end-of-day report).
NOTE: To prevent accidental printing of the "Z" report, set the security code as explained in the SECURITY CODE section.
Once this code is set, a "Z" report will not print until the security code is entered. If a "Z" report is attempted without entering the security code, the prompt "SEC Code" will appear in the display.


PRINTING THE SALES REPORT
IMPORTANT: Once a "Z" reading is taken, it cannot be duplicated, so be sure to have plenty of paper in the register.
1. Set the Control Switch to either the "X" or "Z" position.
2. Press the [amt tend/TOTAL] key.
NOTE: If a security code has been assigned, be sure to enter the security code before pressing the [amt tend/TOTAL]
key.
TO CLEAR THE GRAND TOTAL:
1. Set the Control Switch to the "prg" (Program Mode) position.
2. Type [2], type [0], then press [RA].
After this operation, the grand total resets to zero.

Oct 21, 2011 | Royal 435dx Electronic Cash Register

1 Answer

How to create book type header in docx file means double header, one for tile which must be apply for whole doc. while other tiltle may change after few nuber of pages


this will set the head on every page till you remove it.


On the View menu, click Header and Footer to open the header or footer (header and footer: A header, which can consist of text or graphics, appears at the top of every page in a section. A footer appears at the bottom of every page. Headers and footers often contain page numbers, chapter titles, dates, and author names.) area on a page.
  1. To create a header, enter text or graphics in the header area.
  2. To create a footer, click Switch Between Header and Footer on the Header and Footer toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.) to move to the footer area, and then enter text or graphics.
  3. If necessary, format text by using buttons on the Formatting toolbar.
  4. When you finish, click Close on the Header and Footer toolbar.

Jul 21, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

Bottom sheet numbers have disappeared


Are you using the Custom Footer option?

Click View>Header and Footer...>Custom Footer...

It should have &[PAGE] in the section that you want the Page# to appear. If it does not, click the section where you want it and then click on the icon that has the # sign on it. Click OK.

Thanks for using Fixya.

Sep 28, 2009 | Microsoft Excel for PC

1 Answer

How to create headletter using openoffice 3.1


  • To add a header to a page, choose Insert - Header, and then select the page style for the current page from the submenu.
  • To add a footer to a page, choose Insert - Footer, and then select the page style for the current page from the submenu.
note.png The page style for the current page is displayed in the Status Bar.



  • You can also choose Format - Page, click the Header or Footer tab, and then select Header on or Footer on. Clear the Same content left/right check box if you want to define different headers and footers for even and odd pages.
  • To use different headers or footers in your document, you must add them to different Page Styles, and then apply the styles to the pages where you want the headers or footer to appear.

You type inot the headere space the text you want to seeEG


DR J JONES MBBS FCAS (logo)
address or other information

You can add a smal,picture or logo the exit HEADER and back tpo the main body of the docuement for your Dear Sir/Madam etc.

All this information is in the HELP file of OO


Please rate our help to keep the FREE service online++++Thanks for using FIXYA




Sep 11, 2009 | Sun OpenOffice

2 Answers

My document has a cover and a table of contents. I want page numbering with one to start on the third page. I did do the page break for the cover and the contents and was able to start the document on page...


There are two ways to do this. The first way SOMETIMES works. If you don't have luck, try the second method.

Method 1:
  • Delete the page break between the end of page 2 and page 3
  • Position your cursor at the start of page 3.
  • Click on Insert / Break / Next page
  • Select all the text form page 3 to the end of the document.
  • Click on Insert / Page numbers. UNCHECK "show number on first page"
  • Click on <Format>. Make sure "Start at" is selected and the value is "1". Select <OK>
  • Select <OK>
Method 2:
You need to work with the headers and footers. When you are done, you'll have two different footer sections that are NOT connected.
  • Add a "next page" section break as you did above.
  • Click on View / Header and Footer
  • On the Header and Footer toolbar, Click on the icon for "switch between header and footer"
  • page down to page 3. Click on the "link to previous" icon on the header and footer toolbar
  • Click on Insert / Page numbers. UNCHECK "show number on first page"
  • Click on <Format>. Make sure "Start at" is selected and the value is "1".
For some reason I occasionally have to do this twice to get it to stick but eventually it should work. The key is to make sure you have two separate footer sections; the first section is page 1 and 2 without page numbers then the second section (starting with physical page 3) that has page numbers starting with page 1

Sep 10, 2009 | Microsoft Word 2003 for Students &...

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

Problem in creating report


Crystal Reports comes bundles with VB6 and is a good choice fro reports. Regards -- Joe

Jan 29, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Storage of MS-Access 2007


(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 default.aspx?assetid=za100776681033 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

Jan 16, 2009 | Microsoft Computers & Internet

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

kakima

Level 3 Expert

101711 Answers

k24674

Level 3 Expert

7993 Answers

yadayada
yadayada

Level 3 Expert

68038 Answers

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

Answer questions

Manuals & User Guides

Loading...