Chris Trent
New member
- Local time
- Tomorrow, 00:18
- Joined
- Sep 16, 2020
- Messages
- 3
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.
I'm so frustrated and would appreciate any help.
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.
I'm so frustrated and would appreciate any help.