Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subtotalling a subtotal (2000)

    I've a Report with two group-footers. The inner footer includes [price] and an expression =sum([amount]). I've added an additional expression to this footer, as follows: =[price]*[txtSumAmount], where txtSumAmount refers to the '=sum([amount])' Text Box. This works fine. I now need to add another Text Box to the outer footer, that sums the 'price * txtSumAmount' expression. I've tried several variations. How can I sum up the subtotals obtained in one footer to obtain a grand total in the other footer?

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

    Re: Subtotalling a subtotal (2000)

    Put another text box in the inner footer with Control Source =[price]*[txtSumAmount].
    Set its Visible property to False and its Running Sum property to Over Group.
    Name this text box txtRunningSum.
    Put a text box in the outer footer with Control Source =[txtRunningSum].

Posting Permissions

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