Show only "yes" on report

[meldrape]

Greetings,

I'm sure this is very simple but I don't know how to do it. I have a report that displays a yes/no field value. Right now it's showing both yes and no but I only want 'yes' to display.

access 2000
the field name is "piecework" so if piecework is true I want it to display 'yes' else display nothing...

Any thoughts? Thank you in advance.

 

[straybullet]

In the Yes/No field properties tab (in the table) set the format to ;"Yes";"" . This will show Yes for yes or true values and a blank for no or false values

 

[meldrape]

Many thanks for the reply. The option seems to be yes/no (unless I'm missing something) which was already selected. Anyway, it's not working. It still shows no no no no no no yes no no,etc. when I only need yes. Is there an iif statement of somesort I can write for that field? Thanks anyway.

 

[meldrape]

Hi Straybullet,

I ended up using this is the control source of the report:

=iif(isnull([PIECEWORK]) or [PIECEWORK]=0,"","Yes")

it's working fine now. Thanks again.