Getting a percentage from two numbers

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

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

example:

GoodParts=50 BadParts=50 TotalParts=100

from an exsisting query

Thanks
 
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>
 
Back
Top