Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Footer and totals (2003)

    Today is not my day to be working in Access.....

    I have a report with 2 footers with totals and a report footer with grand totals. The first footer happens when there is a change in audit #, it total the number of records and amounts. It also totals if there is a Status of open and a date field is blank. =IIf([status]="open" And IsNull([rebuttaldate]),1,0). This works great. I also have the fields running sum = over group.

    My next footer happens when there is a change in Company (each company can have more than one audit). This is where my problem is...my totals are not working here.

    My grand total footer is working as well...fields = running sum - over all.

    How to I get my total by company to work??? I have created fields in my detail area to count and add the amount. Again for audit the field would have =IIf([status]="open" And IsNull([rebuttaldate]),1,0) with runnin sum - over group and in my report footer =IIf([status]="open" And IsNull([rebuttaldate]),1,0) with running sum = over all. all the fields are created in my detail area.

    Help....

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

    Re: Footer and totals (2003)

    Try putting a text box in the group footer with control source

    =Abs(Sum([Status]="open" And IsNull([RebuttalDate])))

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer and totals (2003)

    OK...that worked...now how would I write this to add the amounts

    =IIf([status]="open" And ([rebuttaldate]>[dateofletter]),[Reimbursement],0)

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

    Re: Footer and totals (2003)

    Try
    <code>
    =Abs(Sum(([status]="open" And ([rebuttaldate]>[dateofletter])*[Reimbursement])))</code>

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer and totals (2003)

    Hans,

    I get a parameter message to enter Reimbursements. What I need is a formula to add the reimbursements amount for each company?
    Again the way I have it works for the audit footer and report footer but not for the company footer.

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

    Re: Footer and totals (2003)

    Are you sure that the field name Reimbursement is spelled exactly as it is in the record source of the report?

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Footer and totals (2003)

    OK...I get now a whole number such as it counting the recordings not adding the reimbursements amounts.

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

    Re: Footer and totals (2003)

    Could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

Posting Permissions

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