Numeric calculation in form (1 Viewer)

[JamesN]

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

 

[Ranman256]

Build a query, Q1, to count the total of all.
Then make Q2, that uses Q1 to calc the percents,joined on the item...

Select Item, Count(Score)/Q1.TotalOfScore from table,Q1
Where table.item = Q1.item

 

[JamesN]

Thanks for the response Ranman. Once issue I am having is that the yes/no/NA are converted into other text boxes, yes to 1 and no to 0, NA are left blank. When I am totalling the boxes I am getting errors due to the NA being converted as blank? Don't want these going as numbers or text so unsure how to get around this? Is it possible to get it to skip if blank?