Showing Yes/No on a Query instead of .T./.F.

Here's a quick tip if you're experimenting with Queries (Advanced Customizations).

If you've added a "boolean" field, you've noticed that the default values show as ".T." and ".F." (which means True and False).  Most likely you would prefer that it show something like "Yes and "No".  In order to do this, you need to make a change to the Expression.

Whatever it has for the expression, you just need to put that inside an IIF() expression that results in Yes or No.  

For instance, instead of:

Campsites:Site_Inactive

...change it to:

iif(Campsites:Site_Inactive,"Yes","No")

(Note that it's iif with an extra "i", not the word if.)