show percent

[antonyx]

hi..

this is a small problem.. but a big annoyance..

in my report i have a field called 'com'

the value will always be

0.0 or 0.1 or 0.2

only those three..

now when i drag the field into my report.. i am unable to set the format.. (it is just blank)

i would choose percentage.. but i can do it..

where in the report code can i set the following rules

if 0.0 = NC
if 0.1 = 10%
if 0.2 = do not display


ive tried just pasting a line like this into the report code but it doesnt work either

if com.value = "0.1" then com.value = "10%"


anyone??

 

[gemma-the-husky]

what is the source of the field on the report - i'm confused when you say you drag it on to the report

 

[antonyx]

ok, the source is the 'driver_cashwork' query

just look at the report and you will see the 'com'

 

[Rickster57]

display

Insert a textbox in your report next to text43 (com)
Put the following in the control source
=IIf([text43]=0,"NC",IIf([text43]=0.1,"10%",IIf([text43]=0.2,"")))

If all you are doing is changing how the field is visually displayed, use the above.

 

[antonyx]

i think that has done the trick thank you sir