Combo box count

[dianna]

Hi I am new to access. I have a form with 8 combo boxes for 8 different tests e.g. Test1, test2, test3.... test8. I will then selects pass, fail, referred or absent for each tests. If a student passes all eight tests then i will select pass from each combo box for the respective tests. If the student passes test1, test2 I will select pass for test1, pass for test2 and fail or absent for the other tests from the respective combo boxes. I need to count the values chosen in each combo box for each tests and display an overall result such as student has passed all tests. Or If the student was absent for all the tests, display student was absent for all tests. Another criteria is if the student passes 7 out of 8 tests, he is referred, and should display student has been referred. How can i do this? Thanks. Anticipating a favourable response
dianna

 

[pr2-eugin]

Hello Dianna, Welcome to AWF..

Well this is possible.. But needs a bit of coding and also might need a bit more detail, as in how you want to display the result.. Is it a Query you want to do? Or is it in a Form you want to display the information? If it is in a Form; at what point do you wish to see this details?

 

[dianna]

Thank you. I would like to see the information displayed on the form. It should be displayed when the user selects the results of test 8. Does this help? See sample form.