Query results with #Error

  • Thread starter Thread starter cjborntorun
  • Start date Start date
C

cjborntorun

I'm using the following formula in a field of my query:

May % Billed to Fcst: ([May-08 Actual])/([May-08 Fcst])


How can I modify this so that I don't get "#Error" for products that had a
zero (0) forecast?
 
Duane - You are a genius and I thank you

Duane Hookom said:
May % Billed to Fcst: IIf([May-08 Fcst]=0,0,[May-08 Actual]/[May-08 Fcst])
--
Duane Hookom
Microsoft Access MVP


cjborntorun said:
I'm using the following formula in a field of my query:

May % Billed to Fcst: ([May-08 Actual])/([May-08 Fcst])


How can I modify this so that I don't get "#Error" for products that had a
zero (0) forecast?
Click to expand...
Click to expand...
 
Back
Top