Caluclating Percentagees #Error Message

[SB via AccessMonster.com]

Hi

Please can you help with the following, the query works fine when there are
actual values but when the number is 0 it returns an error please see below:

A B C
%
50 5 10
40 4 10
30 0 #Error

The calculation is the following /[A]*100.

Any help will be appreciated.

Many Thanks

 

[John Spencer]

IIF(A<>0,B/A*100,0)

you can put any value in that you want in the above for the value if A is
zero.

 

[shaguftabegum via AccessMonster.com]

just tried it and it worked.

Thank you very much

IIF(A<>0,B/A*100,0)

you can put any value in that you want in the above for the value if A is
zero.

Hi

[quoted text clipped - 14 lines]

Many Thanks