Using VBA to change detail in report to percentage format

[fortwrestler]

Hello,
I was wondering if there is a way to change certain details in a report to a percentage format based upon the value in another field.

I have a report that generates from a crosstab that displays daily stops. However, on this same cross tab, i have an efficiency value. I would like to display the efficiency as a percentage and keep the other values as standard format.

I'm thinking that there is some VBA that goes along the lines like this

IIf(me.SummaryConstant = "EFF", Format(me.day1,"Percent"),"Format(me.day1,"standard"))

and i have it entered on ReportLoad. However this throws an error.

Is there a better way of doing this? Or is it even possible?

 

[CJ_London]

would have thought the place to put it would be in your recordsource as a column

strDay1:IIf(me.SummaryConstant = "EFF", Format([day1],"Percent"),"Format([day1],"standard"))

and use strDay1 in your report

 

[fortwrestler]

I did something similar to that. I have multiple days, but by updating it on the query, it works. Thanks for the reply