Results 1 to 4 of 4
  1. #1
    Alex Motilal is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2008
    Location
    Coimbatore, India
    Posts
    192

    Carried over totals

    Hello everybody,
    If totals run more than one page, is it possible to carry over the totals to the top of next page. ie, page 1 total should be displayed on top of 2nd page. 1st and 2nd page totals should be displayed on top of 3rd page. Is it possible?
    Thanks

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    The answer is always yes.

    On the detail OnFormat accumulate your total in a temporary variable.

    This assumes that you have appropriate grouping which starts a new page. On that event of a new page print the accumulated total in a header on the new page. Accumulate a new page total for the next page. Repeat that for each new page, after the first, for each successive page .

  3. #3
    Alex Motilal is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2008
    Location
    Coimbatore, India
    Posts
    192
    Thanks a lot IIkhoutx
    Can you give me an example.

  4. #4
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    I don't have an example and don't have the time to build one from scratch.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Import a totals value
    By vCallNSPF in forum Access
    Replies: 5
    Last Post: 12-13-2009, 07:01 PM
  2. Expense Totals
    By Nosaj08 in forum Database Design
    Replies: 10
    Last Post: 05-06-2009, 11:35 AM
  3. Group Totals in a form
    By mai1081 in forum Forms
    Replies: 1
    Last Post: 05-14-2008, 06:11 PM
  4. Day of Week Totals
    By ddog171 in forum Queries
    Replies: 1
    Last Post: 03-18-2006, 07:01 PM
  5. query - totals
    By mslieder in forum Access
    Replies: 0
    Last Post: 02-22-2006, 06:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums