How to calculate a percentage on form

[jrockusa]

Hello all,

I am attempting to calculate a percentage on an Access form with the expression builder using the information from the following query results. Please see below. What I need to do is determine the error capture rate for each error type.

For example, for Coding (highlighted in yellow) the formula would be
(35) / (35+6) = 85.36%

Anotherwards, (Error Type "Items Failed") / (Error Type "Items Failed" + Error Type "Fin Err").

Is this possible? Any help would be appreciated. Thanks!



Field 1 Field 2 Field 3

Error Type CountOf Error Type FinErrItemFailed

Coding 6 FinErr
Coding 35 ItemFailed

[pbaldy]

As the control source of a textbox it would look like:

=Field1/(Field1 + Field2)