Results 1 to 2 of 2
  1. #1
    fatboymedic is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Location
    New York
    Posts
    3

    Count a field that meet one of 3 checkbox conditions (trues)

    Hi, I have a database that includes (among others) fields for NAME (3 fields per record) and an "IN CHARGE" checkbox for each NAME field.



    I have already successfully created sum text boxes in a report based on a query of the data that tells me:
    1)total number of records for name
    2)total # of times "in charge" as NAME1
    3)total # of times "in charge" as NAME2
    4)total # of times "in charge" as NAME3

    What I need is a report field that tells me a count (or sum??) of another field (ie:review required) which is a combo box with Y/N/naONLY if checkbox 1,2or3 is TRUE... All 3 checboxes MAY be blank (and therefore wouldnt be counted) i understand i'd have to change the formula slightly to have totals for the 3 different values of the combo box.. the person (name) may be in NAME1,2 or 3 and would only be marked "in charge" if in fact, in charge....

    Im trying to get a result like:

    NAME CRITERIA YES NO n/a
    <----- "in charge"
    review required 5 37 1


    GROUP CRITERIA YES NO n/a I have already
    review required 30 110 4 made these

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,616
    These are Yes/No datatype fields? You want to count only if any one of the checkboxes is checked?

    Sum(IIf(Name1=-1 Or Name2=-1 Or Name3=-1,1,0))
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. compile a field on checkbox selection
    By jsabina in forum Forms
    Replies: 3
    Last Post: 01-06-2012, 01:12 PM
  2. Replies: 7
    Last Post: 11-26-2010, 07:54 PM
  3. Replies: 5
    Last Post: 09-24-2010, 05:04 PM
  4. Query result based upon two field conditions
    By diane802 in forum Access
    Replies: 35
    Last Post: 01-08-2010, 06:31 PM
  5. Replies: 2
    Last Post: 03-31-2009, 11:15 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