Override Values on Report

[Michael]

Hi Folks - I'd like to override certain field values on my report. I have an
account number and account name. Normally, the account number would look
like 234567999, and the account name would look like Joe Smith. However, if
the account number is 999999999, then I want to override the recordsource
field value with "Not Available". I know I can probably do this in the
underlying query, but I would prefer to do it at the report level. Do-able?
If so, where do I start?

Thanks,

Michael

 

[Guest]

To do it in the report, change to control source property of the control for
Account Number:

=IIf([AccountNumber] = 999999999, "Not Available", [AccountNumber])

 

[Michael]

Never mind folks .... I used calculated fields to solve my problem. I like
simple fixes.