Turning 5% to 95%

[Gabriel2012]

Hello all, so here is my predicament; I am calculating an avg, in a query, based on two fields "CountofErrors" / "OrdersAudited". This of course is giving me a low number, so for instance 10 errors / 100 - 10%. However I need to reverse the number and turn a 10% error rate into a 90% accuracy. In excel I would simply type =100%-(formula) however this is not working in access, any suggestions?



Thank you!

[JoeM]

How about using this logic:
(OrdersAudited - CountofErrors) / OrdersAudited

[RayMilhon]

Try this 1-(countoferrors/ordersaudited) In Access the number stored is a real number so 2% = .02

[Gabriel2012]

Bravo! Many thanks!