Results 1 to 3 of 3
  1. #1
    Chris Trent is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Sep 2020
    Posts
    6

    Unhappy Find count of drop down box selections in a specific record

    Hi Everyone

    Please could you assist me. I am not very advanced when it comes to MS Access so i would appreciate a step by step guide if possible.

    I have a database to track different kinds of cleaning carried out. The table consists of quite a few columns as they are all questions that need to be answered. The question answers come from combo boxes. The options are Yes, Partially or No.

    I would like to create a query to be used in a report that counts the number of questions that had an answer "Yes" so that I can work out the percentage the task was completed. For example, if the form as 10 questions in total and 6 were answered with "Yes", then I know it was 60% complete. I'm not experienced in SQL but I have tried building various queries in the Query Design screen and in SQL examples but I cannot find what I am looking for.

    I would like to pull the number of "Yes" answers per record, not the total number of records containing "Yes". It would be great if i could store the number of Yes per record in the table. I am using Access 2010 64-bit.



    DB Demo: https://drive.google.com/file/d/15rR...ew?usp=sharing

    I'm so frustrated and would appreciate any help.

  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,820
    Recent thread with this same issue https://www.accessforums.net/showthread.php?t=81666

    Your table structure is not normalized which is big source of frustration.

    Another approach may be to rearrange fields to normalized structure with a UNION query then use that query as source for an aggregate query.


    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
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I spent some time and modified your dB to be more normalized ..... but there are still issues. You did not include all the tables in your dB. Plus, I did not create a lot of the forms needed to add/edit static data such as the questions of cleaning.


    The db got too big to compress and post in the thread, so I had to put it in Box... here is the download link: https://app.box.com/s/6qr3ncpu36rno82832zedy2at1son1re


    Ask if you have questions on what I did....

    Good luck with your project.

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

Similar Threads

  1. Replies: 40
    Last Post: 04-06-2020, 06:49 AM
  2. Drop Down to list to specific record
    By googalabosh in forum Forms
    Replies: 2
    Last Post: 01-22-2020, 01:28 PM
  3. Replies: 8
    Last Post: 08-23-2019, 07:19 PM
  4. Specific Record Count
    By FormerJarHead in forum Queries
    Replies: 3
    Last Post: 08-23-2013, 11:02 AM
  5. Trying to find a specific Record using VBA
    By FormerJarHead in forum Programming
    Replies: 26
    Last Post: 11-12-2012, 07:11 PM

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