#Error on IIf Statement

  • Thread starter Steven M. Britton
  • Start date
S

Steven M. Britton

=IIf(([Billing_UpSell2]=0),Null,[Billing_UpSell2])

this gives me an Error in the field and I don't understand
why. The value comes from a query that is off a table,
the table has the datatype and Number.
 

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

Incone & Expenses Statement 0
IIf works in query but not in report 1
Data Mismatch in Excel 2010 4
IIF statement help 13
IIf statement 9
string together IIf statements into one text box? 3
if it is null how not to get the #error 1
IIf statement 4

Top