Logically assign values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have numeric values in my report, some are money and some are codes
representing error conditions. I want to display for example "Non-Budgeted
Expense" in case a value -9999 is present, but if it's not then I just want
the value. I have tried the following and I get a circular reference error.
=IIf([M_Sales_Expense]=9999,"Non-Bugeted Expense",[ M_Sales_Expense])

I also tried referencing the query and was prompted for a parameter when
changing to Report view.
[rptqrySales_Expense_Detail].[ M_Sales_Expense]

Any thoughts?
 
Do you realize you have a space betwee [ and M? Also you mention -9999 but
your expression omits the -.

Do you have controls named the same as fields?
 
Back
Top