Format a text box in a sub-report

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

Guest

I am attempting to set the format of a text box in a sub-report to Percent.
When I click on Format in the properties, my pull down menu list is blank.
Typing in Percent does not work either. Changing the format in the query
that supplies the information does not work either. The field that I am
trying to format is an expression that divides the sum of one field by the
sum of another field with an IIF statement in case the denominator is 0. Any
suggestions?
 
Wrap your IIF() in the Val() function so you have something like
YourColumn: Val(IIf([FieldA]=0,0,[FieldB]/[FieldA]))
 
Back
Top