Results 1 to 3 of 3
  1. #1
    Chakota is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2020
    Posts
    9

    Counting Selected Responses from a Single Field

    Not new to Access (definitely not an expert) but am new to posting in a forum, so please excuse any rookie mistakes. Need some help on using the Count feature on a report. If the response in a field is Yes and No, and I want to know the singular total of how many YES responses I have, in the control source of a text box I’m using =Count(IIf([fieldName]="Yes",0)) and I get my answer. The issue I have is on some reports, the field may have multiple responses (Yes, Sometimes, Seldom, Never). If I want the text box to give me total count of say YES and SOMETIMES combined, I’m not sure how to express that. I’ve tried different variations of the =Count attempting to join them to provide a cumulative, but the result is a 0 total. Any help would be appreciated.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    What do you mean by 'the field may have multiple responses' - not for the same record but the data is that varied throughout the records?

    =Count(IIf([fieldName]="YES" Or [fieldName]="Sometimes",1,Null))

    or

    =Sum(IIf([fieldName]="YES" Or [fieldName]="Sometimes",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.

  3. #3
    Chakota is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2020
    Posts
    9
    Thank you June7, that's just what I needed. I was overthinking it.
    Answering your questions, I have combo box with multiple selections in it, and needed combined totals of specific responses.
    Appreciate the assistance!

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

Similar Threads

  1. Counting Responses on a Form
    By Anagnorisis in forum Forms
    Replies: 1
    Last Post: 03-22-2017, 08:22 AM
  2. Counting Multiple Dates in a single Field.
    By Woblypegs in forum Queries
    Replies: 2
    Last Post: 02-09-2015, 06:10 AM
  3. Counting Specific Duplications in a Single Table
    By alpinegroove in forum Queries
    Replies: 13
    Last Post: 08-19-2014, 11:56 PM
  4. Counting fields in a single record
    By Racingrl in forum Queries
    Replies: 2
    Last Post: 06-11-2012, 10:52 AM
  5. Conditional Responses in Form
    By jheintz57 in forum Forms
    Replies: 7
    Last Post: 03-31-2010, 09:57 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