Logically assign values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LP - 29 Jul 2005 21:33 GMT

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?

Reply to this Message

Duane Hookom - 29 Jul 2005 21:54 GMT

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?

Signature

Duane Hookom
MS Access MVP
--

>I have numeric values in my report, some are money and some are codes
> representing error conditions. I want to display for example
[quoted text clipped - 10 lines]
>
> Any thoughts?

Reply to this Message