Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculating Check Boxes on a Report (2003)

    Hi All,
    I have been working on a report for a couple of days trying to figure out how I can get percentages on a report that has checkboxes.
    I have already totaled the checkbox columns using =sum(abs([field A]+[field B])) in the Detail, Date, Unit and Report footer sections.

    I cannot figure out how to take the total of one calculation and create another that shows the percentage. For example: I need to add columns A and C, then add columns B and D, then [AC] / [BD] on the report in all sections fo the percents.

    Perhaps (or more probable) I have been going about it all wrong? I have included a stripped down version of the database, query and report that I am working on. There are records in it from 10/01/06

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Check Boxes on a Report (2003)

    I think the attached does what you want.

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

    Re: Calculating Check Boxes on a Report (2003)

    You can use a text box with control source

    =Som(Abs([InfluenInfoNotInUserDefined]+[PneumoInfoNotInUserDefined]))/Som(Abs([Influenza]+[Pneumonia]))

    and set its Format property to Percent with the desired number of decimal places.

  4. #4
    Star Lounger
    Join Date
    Mar 2004
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculating Check Boxes on a Report (2003)

    Thank you so much, it's perfect.
    I was not using the " /Sum(Abs" again (the second time).

Posting Permissions

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