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

Top  Previous  Next

DISCLAIMER: This article involves Advanced Customizations, which can be technically challenging to get working and is not part of standard support.  This is programming and must be done precisely or the results can be unpredictable.  This information is provided as a service for those who have the technical skills to work through it -- we cannot help you solve any issues with getting it working.  For more information about Advanced Customizations, see the full documentation:

https://campgroundmaster.com/help/overview32.html

 

 

 

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.)

 


Page URL https://CampgroundMaster.com/news/showingyesnoonaqueryinst.html

Campground Master Home