HI,
I'm currently migrating an excel scoring document into an access form. Within the excel file there are 8 line items which are scored with Yes/No/NA. A formula is in place to sum the total applicable and divide by the no of fails to give a %.
So far the access form is built but i need to add the calcs to populate this % score. I have 8 combo boxes with the Yes/No/NA drop downs.
What's the best way to proceed to total the no of passes/fails etc in the combo boxes?
Thanks
I'm currently migrating an excel scoring document into an access form. Within the excel file there are 8 line items which are scored with Yes/No/NA. A formula is in place to sum the total applicable and divide by the no of fails to give a %.
So far the access form is built but i need to add the calcs to populate this % score. I have 8 combo boxes with the Yes/No/NA drop downs.
What's the best way to proceed to total the no of passes/fails etc in the combo boxes?
Thanks