K
k12345
I am not very skilled in Access and need to create a very basic form for
quality assurance. I have the form set up with a set amount of questions and
a score box next to each one. I have built an expression in the final box
where I am able to add all of them and divide by the amount of standards to
come up with the average. This is the problem: I need to be able to also
include "N/A" as an answer and make sure that the question that has this will
not be included in the final average. This could be different every time
depending on the case. Some may have 1 or another may have 5 and need to
make sure that the expression will change the number I need to average with...
.. Am I making any sense?
Any help would be appreciated.
Thank you.
quality assurance. I have the form set up with a set amount of questions and
a score box next to each one. I have built an expression in the final box
where I am able to add all of them and divide by the amount of standards to
come up with the average. This is the problem: I need to be able to also
include "N/A" as an answer and make sure that the question that has this will
not be included in the final average. This could be different every time
depending on the case. Some may have 1 or another may have 5 and need to
make sure that the expression will change the number I need to average with...
.. Am I making any sense?
Any help would be appreciated.
Thank you.