How do I set up 0 value or 1 in access

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))))
 
S

Steve Schapel

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]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculations based on varying number 1
Weighted averaging of dates 3
Databse crashed if SQL strin runs from CurrentDb.Execute method 2
Query 9
how do i calculate exponential moving average in microsoft access 1
Query to Filter by Dates, Using Form 7
Populate empty cells to use for conversion 1
Certain jobs only need certain training... How to set up... 1

Top