Adding Subreport Subtotals on the main form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • xian2
    New Member
    • Nov 2006
    • 43

    Adding Subreport Subtotals on the main form

    Hi,

    I have two subreports on my report and they both have a subtotal in the subreport footer section.

    I have managed to work out how to call the subtotals in to the main form:

    Code:
    =[Reports]![rptInvoice]![tblToursOffered subreport].[Report].[Text12]
    Code:
    =[Reports]![rptInvoice]![tblAdditionalCosts subreport].[Report].[Text14]
    But I have no idea how I add them now.

    i have tried a simple Sum function but with no luck.

    Any help much appreciated.

    Many thanks in advance

    Edd
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Try this ...

    Code:
    =[Reports]![rptInvoice]![tblToursOffered subreport].[Report].[Text12] + [Reports]![rptInvoice]![tblAdditionalCosts subreport].[Report].[Text14]
    Mary

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32634

      #3
      Please visit this thread to see why we would rather you didn't double-post (Please do Not Double Post ).
      This question has been asked and answered in another of your threads. Please understand that this wastes our time and reduces our ability to answer other members' threads (Problem Totalling Subreport on Main form).

      Comment

      • xian2
        New Member
        • Nov 2006
        • 43

        #4
        Hi,

        Sorry I wasnt intending to double post, I started the second post because I was technically asking a second question in the first post so thought it better to start it in a new post for anyone searching in the future.

        Sorry, it wont happen again, and thanks for all your great help on all my questions NeoPa and Mary especially.

        Edd

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32634

          #5
          You're cool Edd.
          It's ok to do as you did, but you need to explain that you're doing it with a link. That way it's all clear.
          Glad you're happy with the answers anyway :)

          Comment

          • MMcCarthy
            Recognized Expert MVP
            • Aug 2006
            • 14387

            #6
            Originally posted by NeoPa
            You're cool Edd.
            It's ok to do as you did, but you need to explain that you're doing it with a link. That way it's all clear.
            Glad you're happy with the answers anyway :)
            And we both gave the same answer. That must be a first. :D

            Comment

            • NeoPa
              Recognized Expert Moderator MVP
              • Oct 2006
              • 32634

              #7
              Surely not the first Mary. You've certainly been right before now :D

              Comment

              • xian2
                New Member
                • Nov 2006
                • 43

                #8
                Haha,

                Are there no rules regarding personal banter within posts containing serious questions :-)

                Thanks for all your help guys

                Edd

                Comment

                • MMcCarthy
                  Recognized Expert MVP
                  • Aug 2006
                  • 14387

                  #9
                  Originally posted by xian2
                  Haha,

                  Are there no rules regarding personal banter within posts containing serious questions :-)

                  Thanks for all your help guys

                  Edd
                  You're welcome.

                  Comment

                  Working...