Data Report

Hello,

I have Access as my back-end. One of my fields is of boolean type. In the VB form I have a check box to input in this field. Now when I click this input form ( when value is true ) -1 is input in the Access and 0 for false.
That's OK. BUT now the thing is I want to display this field in a data report and what is being displayed is -1 for true and 0 for false. But I want that a "YES" is printed for 1 and a "NO" is printed for 0 in the report.
How do i do this. Any help will be highly appreciated.

Thanks
Kaustubh

Hi

You can to create a query in Access and insert a calculed field. Ex.: iif(field=-1,"YES","NO")

Set in your data report this query and print this field calculed

Iron Man

Thanks a lot. Ur solution is spot on. Also please read the new post I have posted. It's about runtime Data reports.
Please see if u can help me there.

Million Thanks

Kaustubh