Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    May 2004
    Location
    Pardeeville, Wisconsin, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a report 1st grouped on Contract received date. This Grouping shows all of the contracts received in each month.

    My second grouping is by payment type.

    Calculations are set on payment, balance due, upgrade price and number of booths. All calculations include sums in each payment type and in the Contract Received footer. We want to show in each monthly total how many booths are available at the end of each month. There are a total of 380 booths. For the end of January there are 357 booths left. In the month of Feb. 11 booths were sold leaving a balance of 346 booths.

    I just don't seem to be able to wrap my mind around how this could be accomplished.

    Your help in clearing the fog is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Create a duplicate of the Sum of Booths text box in the group footer.
    Set its Visible property to No (it will only be used for calculations).
    Set its Running Sum property to Over All.
    Name this text box (for example) txtRunSum.

    Place a text box in the group footer (for months) with control source

    =380-[txtRunSum]

    This text box should display the number of remaining booths.

  3. #3
    Lounger
    Join Date
    May 2004
    Location
    Pardeeville, Wisconsin, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='783408' date='07-Jul-2009 14:21']Create a duplicate of the Sum of Booths text box in the group footer.
    Set its Visible property to No (it will only be used for calculations).
    Set its Running Sum property to Over All.
    Name this text box (for example) txtRunSum.

    Place a text box in the group footer (for months) with control source

    =380-[txtRunSum]

    This text box should display the number of remaining booths.[/quote]

    Thanks you are awesome!!!

Posting Permissions

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