Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    3

    Question Unanswered: Calculating subreports

    Hiya

    I have two subreports on my main report and need to add the totals of both subreports to give me a grand total.

    Anyone have any idea of what i'm supposed to be typing in my txt box?? Having a blond moment can't think.

    Cheers

  2. #2
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    Use the follwoing syntax to refer to the subreport field

    GrandTotal = [SubReport1Name].[Report]![SubTotalField1name] +[SubReport2Name].[Report]![SubTotalField2name]

Posting Permissions

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