Getting a percentage from two numbers

[Dan]

Dumb question...
How do I get the percentage from 2 numbers.

example:

GoodParts=50 BadParts=50 TotalParts=100

from an exsisting query

Thanks

 

[Jeff Boyce]

Dan

Mathematically, a percentage is one number divided by another. You can do
this in a query by showing one field divided by another, something like:

[Field1]/[Field2]

in a blank 'cell' of the Field row.

Good luck

Jeff Boyce
<Access MVP>