Undefined function IF in Expression

  • Thread starter Thread starter KrispyData
  • Start date Start date
K

KrispyData

I am trying to use this funcition in a query. Access is giving me the
message that I put in the subject line of this question. What appears to be
wrong with the function? The reason I am doing this is because I want a 0 to
appear instead of error message if the denominator is 0.

IF([t_OCProfit_FINAL]![NF_Sales]=0,0,([t_OCProfit_FINAL]![NF_Sales]/[t_OCProfit_FINAL]![OC_Sales]))
 
Thanks, Dirk! Your suggestion worked.
Thanks so much for all your help!
 
You must log in or register to reply here.

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

Undefined function 'concatenate' in expression 0
Access #Error & Excel Pivot 0
undefined function? 1
Undefined function in expression 4
Query error: Undefined function 'Concatenate' in expression 3
"Undefined Function" in Expression when using VBA module in query 1
Undefined Function error - Complex 3
Undefined Function 4

Back
Top