Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397

    Unanswered: IIf([Page]>1,"","Continue On Next Page...")

    Hi,

    1. If my report pages are not more than 2 then

    =IIf([Page]>1,"","Continue On Next Page...")

    code in a text box on report would work. But incase the report pages are more than 2 what will be the code?

    2. In report, how can I display total of first page at first line on the second page and total of first & second page at first line on third page and so on..?

    All are well come with their suggestions..

    With kind regards,
    Ashfaque

  2. #2
    Join Date
    Jan 2005
    Location
    Nanded, India
    Posts
    397

    Got the answer...

    Hi all,

    My first question was:

    To print 'Contd. On Next Page...[page number]" what will be the code incase the report is more than 1 page ?
    I got the answer after my several try. Just place an unbound text box at the bottom of your report and type the following code into it.

    =IIf([Page]<[Pages],"Contd. On Next Page..." & [Page]+1,"")

    If report is more than 1 page, it will show you text Cond..On Next Page...2 at the first page. And likewise on the next page if some more pages are there. It will show nothing if report is only on one page also will not show on the last page.

    Can somebody answer to my second question from the thread?

    With kind regards,
    Ashfaque

Posting Permissions

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