How do I set up 0 value or 1 in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I have typed this macro in my access database and didn't work. I just want
to know how would I do if I get any nymbers or 0 value for the feild avarage
failed size.

(([Average Win Size]/[Average Fail Size," "])*((([Winning Trades]/([Winning
Trades]+[Failed Trades]))*100)/(100-(([Winning Trades]/([Winning
Trades]+[Failed Trades]))*100))))
 
Champs,

Shooting in the dark here, but I guess you can replace this...
([Average Win Size]/[Average Fail Size," "])
with this...
([Average Win Size]/IIf(Nz([Average Fail Size],0)=0,1,[Average Fail
Size]))
 
Back
Top