or equal to The condition formed by the above comparison operators is evaluated to result into TRUE or FALSE. <Value- > This value is returned by IIF() function to the field, if the condition turns out to be TRUE <Value- > This value is returned by IIF() function to the field, if the condition turns out to be FALSE Example : Suppose a field Type is to return the string of characters “Debit” when its value is and “Credit” when its value is , IIF() function is used as shown below : IIF (Type = , “Debit”, “Credit”) (b) Abs : The purpose of this function is to return absolute value, This function receives a numeric value as its input argument and returns an absolute value. Consider the following examples on use of Abs ( ) function : When – is given as input argument to Abs(– ), it returns When is given as input argument to Abs( ), it returns (c) Val : The purpose of this function is to return the numbers contained in a string as a numeric value of appropriate type. Its Syntax is Val (string) The string argument of the above Val( ) function is any valid string expression.
The Val( ) function stops reading the string at the first character that cannot be recognised as number. For example, Val(“12431”) returns the value 12431 by converting the enclosed string of numerals into value. However, Val (“ , ”) returns the numeric value because comma after in the enclosed string of characters in Val ( ) function is not recognised as number.