Division by zero

L

libby32

Registered User.

Local time

Today, 21:31

Joined

Mar 6, 2003

Messages

42

• Mar 25, 2003

• #1

Hi, sometimes a value will nedded to be divided into zero. When this happens, I need the answer to calculate to zero to be used in another calculation. Here is the code in the query that I am using to try to convert to 0 but it is not working...What have I done wrong??

LgQty: IIf((Nz([WtInLg])/Nz([No_Lg_Containers])*nz([LgfrWharf])=0,0, (Nz([WtInLg])/Nz([No_Lg_Containers])*Nz([LgfrWharf]))))

 

FoFa

Registered User.

Local time

Today, 15:31

Joined

Jan 29, 2003

Messages

3,672

• Mar 25, 2003

• #2

You can't divide by zero.
You must check the value for zero, and return zero, else divide

 

S

Shadez

Registered User.

Local time

Today, 21:31

Joined

Jan 20, 2003

Messages

192

• Mar 25, 2003

• #3

try somthing like this

=iif(nz(SomeField,0)=0,0,AField/SomeField)

This will check if somefield is 0 or empty if so return a 0 else do the calculation.

ie

IIf((Nz([WtInLg])/Nz([No_Lg_Containers])*nz([LgfrWharf])=0,0, (Nz([WtInLg])/Nz([No_Lg_Containers])*Nz([LgfrWharf]))))

Would be

iif(Nz([No_Lg_Containers],0)=0,0,Nz([WtInLg])/Nz([No_Lg_Containers])*Nz([LgfrWharf]))

this approch works


ShadeZ

 

Freddy

Abort, Retry or Ignore?

Local time

Today, 16:31

Joined

Jul 25, 2002

Messages

28

• Mar 25, 2003

• #4

You have to test the denominator for zero. Then either pass a 0 for the full calculation.

Try this: LgQty: IIf(Nz([No_Lg_Containers])=0,0,(Nz([WtInLg])/Nz([No_Lg_Containers])*Nz([LgfrWharf]))))