Results 1 to 2 of 2
  1. #1
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147

    Sum by Qtr in a Report

    I want to count how many (FindingTotal) I have done by quarter (dateofaudit) in my report.



    I used this formula to get my numbers for the year: =Sum(IIf(Year([dateofaudit])=2011,[FindingTotal],Null))

    Now I need to the same but break it down to quarters. How would I convert this to quarters. Thanks!

  2. #2
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147
    Here is the formula that I am using for each textbox. I need to find a percntage of each qtr.
    Findings: =Sum(IIf([Qtr]="1 Qtr - 2011",[FindingTotal],Null))
    Consents: =Sum(IIf([Qtr]="1 Qtr - 2011",[TotalConsents],Null))

    Findings return is: 356
    Consent return is: 32

    The code I am using but is returning the wrong percentage is:
    =Sum(IIf([Qtr]="1 Qtr - 2011",[FindingTotal],Null))/[totalconsents]

    It is returning: 10.6667 but it should be 11.125

    What am I doing wrong? This is driving me crazy!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 12-13-2010, 05:33 PM
  2. Replies: 2
    Last Post: 08-25-2010, 01:42 PM
  3. Replies: 3
    Last Post: 05-21-2010, 03:57 PM
  4. Replies: 1
    Last Post: 02-02-2009, 05:52 AM
  5. Replies: 0
    Last Post: 10-24-2008, 11:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums