>Is there a command to return the character equivalent of a specified logical expression? Just like the STR() command to return the character equivalent of a specified numeric expression.
IIF( YourLogicalExpr, "Y", "N")
IIF( YourLogicalExpr, "Yes", "No")
IIF( YourLogicalExpr, "Oui", "Non")
IIF( YourLogicalExpr, "Affirmative", "Negative")
IIF( YourLogicalExpr, "Aye", "Nay") etc., etc.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
