Help - query %

[djunkins]

Please help. I know that [BadParts]/[GoodParts] =%of BadParts.

I'm trying to get the % of goog parts. I've tried several formulas in the critera but nothing seems to work.


Can Someone please help me.


Thank you,
Dan

 

[awingnut]

I'm not sure what you are getting that you don't think works. However, I believe the correct formula for percent of bad parts is:

100% * [BadParts] / ([GoodParts]+[BadParts])

Example: 10 bad parts and 90 good parts would be 10% bad parts. 100% * 10 / (10 + 90) = 1000% / 100 = 10%

 

[djunkins]

Thank you,
but that's the same results i'm getting already.

I have the percent of bad parts.
I'm trying to get the percent of good parts.
example:
10 bad parts, 90 good parts = 90% good parts.

In excel this is a piece of cake but the formula does not work the same in access.

 

[awingnut]

The formula would only be different in the numerator:

100% * [GoodParts] / ([GoodParts]+[BadParts])

Example: 10 bad parts and 90 good parts would be 90% good parts. 100% * 90 / (10 + 90) = 9000% / 100 = 90%

 

[djunkins]

THAT IS SO TOTALLY IT !!!

Geez, I've tried so many other formulas. People had me writting codes so long, I knew it had to be simple.


Thank you very much!!!


Dan