Access 2010 report conditional formatting IIf statement
Posted on 2013-01-17
Hi just trying to apply conditional formatting to a certain section of my report.
I need to differentiate one set of values as a number rather than a percent. All are set as percent right now, but if the domain equals a certain value, I need it to format the fields in the section as a number (not a percent) and for all else, they need to stay percents.
IIf([domain]="auth_dispo_amtpmpm",Format([panel_%], “Standard”),Format([panel_%], “Percent”))
Those examples have been what I am trying to do, but it won't work, please help.