Expression in query #Error how to fix this

  • Thread starter Thread starter Juan
  • Start date Start date
J

Juan

Hello I have a query with the following expression:
QTR 1 %: ([QTR1 WON]/[QTR1 KCZ])
This works fine, but if the QTR1 WON and QTR1 are Zero
then I get following thing in the field #Error
is there a way to not get this, perhaps put a Zero or
leave blank?

Please advise any info, really appreciate it.

thanks,

juan
 
Try something along the lines of
QTR 1 %: IIF(Nz([QTR1 KCZ],0) = 0,0,([QTR1 WON]/[QTR1 KCZ]))

Hope This Helps
Gerald Stanley MCSD
 
Hello Gerald,
thanks alot for your help. This looks good.
Appreciate the help.

Thanks,
Juan
-----Original Message-----
Try something along the lines of
QTR 1 %: IIF(Nz([QTR1 KCZ],0) = 0,0,([QTR1 WON]/[QTR1 KCZ]))

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
Hello I have a query with the following expression:
QTR 1 %: ([QTR1 WON]/[QTR1 KCZ])
This works fine, but if the QTR1 WON and QTR1 are Zero
then I get following thing in the field #Error
is there a way to not get this, perhaps put a Zero or
leave blank?

Please advise any info, really appreciate it.

thanks,

juan
.
Click to expand...
.
Click to expand...
 
Back
Top