I have created a union query, The query works correctly the only problem is that one of the fields types in the query is Boolean, The query now displays “-1”and “0” rather than “Yes” and “No”. I understand why it is showing “-1” and “0”. However is there a way I can get the query to display the values “Yes” and “No”. I was hoping to dump the query in to a .xls spreadsheet to send to the users. It would be easier to explain a Yes/No value rather then “-1”and “0”.
Boolean Display Values in Union Query
- Thread starter msp
- Start date
