Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Columns (Access 2002)

    I'm generating a report of items ordered/monies owing. The report details uses columns to keep the report to a manageable size.

    In the report footer, I have an overall total (an important figure which I must have) but it appears on a new page as it (the footer) is not part of the columns. Is there a way to avoid forcing a new page, and have the total appear at the foot of the last detail element?

    Thanks

    **************************************
    Colin McDonald
    colinmac@blueyonder.co.uk
    **************************************

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Report Columns (Access 2002)

    You could try putting the text control with the sum in it in the Page Footer setting it's visible property to false. Then put code in the Page footer to set the visible to true if Page = Pages.
    Be careful, when testing the Pages field only shows a value when printing not in preview.
    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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