Hello,
I have a query that selects a field that has a BIT type.
Basically I need an expression what outputs the word "Yes" if the BIT value is 1 or "No" if the BIT value is -1.
Any ideas?
Thanks.
Hello,
I have a query that selects a field that has a BIT type.
Basically I need an expression what outputs the word "Yes" if the BIT value is 1 or "No" if the BIT value is -1.
Any ideas?
Thanks.
Did you mark this as Solved in error? If not, do you want to share your solution?
I marked it solved intentionally.
Solution: iif([Field]=1,"Yes","No")
Thanks for posting back with your solution.