Results 1 to 2 of 2
  1. #1
    DaveC is offline Novice
    Windows XP Access 2002
    Join Date
    Jun 2014
    Location
    Connecticut USA
    Posts
    17

    Counting occurrences of specific data

    I have a report based on a query and would like to display a text box that shows the number of occurrences of a specific value in the returned data.

    Example, a text column named TestResults can contain PASS, FAIL, or UNTESTED. How can I show the total number that have PASSED?

    Thanks

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904

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

Similar Threads

  1. Counting Specific Duplications in a Single Table
    By alpinegroove in forum Queries
    Replies: 13
    Last Post: 08-19-2014, 11:56 PM
  2. Replies: 7
    Last Post: 09-01-2013, 01:04 AM
  3. Counting values after a specific value
    By cardgage in forum Queries
    Replies: 5
    Last Post: 03-12-2013, 07:41 AM
  4. Specific record counting in Reports
    By Duncan in forum Reports
    Replies: 2
    Last Post: 11-08-2012, 02:54 PM
  5. Replies: 2
    Last Post: 06-08-2012, 11:22 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