I have a query with the following IIF statement
It gives the correct results, but the format that it gives them is what I am struggling with. It responds back with 0 or -1. I want it to respond TRUE or FALSE.
How can I change this other than making TRUE and FALSE strings? I still want them as boolean values.
This is how TRUE and FALSE work in VBA (and Access): https://stackoverflow.com/questions/4275800/what-are-the-integer-values-of-boolean-false-and-true-in-vb6
If you want a 1 and a 0 like most other programming languages, return 1 and 0 and evaluate that instead of using the keywords TRUE and FALSE. That will make it consistent with other languages, but it won't be internally consistent with Access/VBA.
Something like this:
I have three columns in access (MS- Access 2013) A B and C. A & B has mobile numbers. I want to show MD in column C if A & B has same values or AD as column A and B has different values.