M
m20ael
Guest
I want to select from a combo in a form the option either "Yes" or "No" but then display either "Y" or "N" respectively in a report. How?????
I have the box in the form all set up and I'm now trying to manipulate the data in the report. I have tried, in the expression box, this....
=IIf([Truant]="Yes","Y","N")
but this diplays a #Error.
The combo on the form is either yes or no but I only need a Y or an N on the report - am I on the right lines - or should I try something else?
Can someone please help?
Thanks
I have the box in the form all set up and I'm now trying to manipulate the data in the report. I have tried, in the expression box, this....
=IIf([Truant]="Yes","Y","N")
but this diplays a #Error.
The combo on the form is either yes or no but I only need a Y or an N on the report - am I on the right lines - or should I try something else?
Can someone please help?
Thanks