Override Values on Report

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
To do it in the report, change to control source property of the control for
Account Number:

=IIf([AccountNumber] = 999999999, "Not Available", [AccountNumber])
 
Never mind folks .... I used calculated fields to solve my problem. I like
simple fixes.
 
Back
Top