Results 1 to 7 of 7

Thread: sum pages (2k)

  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sum pages (2k)

    i have a tbl contain feald ( numbers) i want to do sum of each page alone ( the 1st page sum not add to the 2nd page )
    Ashraf

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: sum pages (2k)

    You can't sum tables at all. You can sum values in queries according to criteria or you can sum values over groups in a report. If you explain further perhaps someone can help you with what you're trying to do.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sum pages (2k)

    SORY !!! i mean sum pages in the report .
    ashraf

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sum pages (2k)

    Microsoft had an example of summing data by page in the Report Samples database for Access 97. I have attached a demo based on that. You'll have to convert it from Access 97 to Access 2000.

    HTH, Hans
    Attached Files Attached Files

  5. #5
    New Lounger
    Join Date
    Mar 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sum pages (2k)

    Thanks 4 u Hans v for ur example , but i folowo the steps but the last page not apear the sum .i do not why .
    Ashraf

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: sum pages (2k)

    Hello Ashraf,

    I don't quite understand what you wrote. Do you mean that the page sum appears on every page, but not on the last page of the report? In that case, open the report in design view, make sure that the Properties window is visible, and look at the Page Footer property of the report. It should be set to "All pages". If it's set to something like "Not with report footer", the page footer won't be printed on the last page of the report.

    Regards, Hans

  7. #7
    New Lounger
    Join Date
    Mar 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sum pages (2k)

    Dear Hans Thank u very much for ur adivce , it work now good
    Ashraf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •