Previous Thread

8/10/2006 5:56:02 PM    How do I set up 0 value or 1 in access
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))))



8/11/2006 8:26:52 PM    Re: How do I set up 0 value or 1 in access
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])) 
 
-- 
 
Steve Schapel, Microsoft Access MVP 
 
champs wrote: