IIF formula in Access Query

[dionicia]

Hi.

I am trying to get a formula in a query to calculate the percent from two different fields and if the results are greater than 100%, just show 100%.

I'm using the follow formula:

IIF([Not Accepted]/[Count of Entry]< 100, [Not Accepted]/[Count of Entry], 100)

The only problem is that it's not coming back with 100 if the amount is greater than 100.

Am I missing something?

Thank you.

 

[John Big Booty]

If you are trying to work out a percentage then perhaps your formula should be;

IIF(([Not Accepted]/[Count of Entry])*100< 100, ([Not Accepted]/[Count of Entry])*100, 100)