zkanoca
Reputation: 9928
Converting a boolean field to 'yes' or 'no' statement on select
We can convert a boolean field in MySql with
select if(bool_field_name, 'yes', 'no') ...
How can I do something like this in Access?
Upvotes: 2
Views: 565
Answers (1)
Gordon Linoff
Reputation: 1270191
The function is iif():
select iif(bool_field_name, 'yes', 'no')
Upvotes: 2
Related Questions
- SQL: Change result of SELECT based on boolean value
- How to have Yes and No as row values in an MS Access query of Yes/No fields?
- SQL - Alter query output based a boolean in the record
- access 2010 how to check if yes/no field is checked
- How to output a boolean from a query
- Access query to make column that shows checkbox for Yes/No column
- Reversing Yes/No field during Select in Access
- Select Dummy Boolean Column SQL / Access
- Using iif clause in Ms Access for a column with "Yes/No" Data Type
- MS Access 03 Query using Yes/No Data Type