Expression for Query.................

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

Guest

I am doing a stats database and I would like to query data for the following.

FTM/FTA and get the percentage, I did this one OK but I get a error in the
field when the percentage is zero. 1/2 = 50% work but when 0/1 or 0/0 give
me a zero.

In excel I could do a if then statement to correct this, how would I do it
in query.
 
You must check for the divide by zero with an expression like:
=IIf(FTA=0,0,FTM/FTA)
 
Back
Top