CPSC-2200 Lecture Notes - Lecture 3: Iif, Logical Connective, Railways Act 1921
20 Nov 2017
School
Department
Course
Professor
Document Summary
Caption property property which specifies a fields column headings in datasheets and label value in forms and reports. If not specified access uses the field name. Any character, # - any digit, * - one or more of any characters). In operator comparison operator (or function) which allows you to specify a list of two or more values for a field that will result in a true comparison. Not operator logical operator which negates the condition specified in a criterion. Selecting multiple columns in a query press and hold the shift key. Ampersand (&) operator string operator which concatenates or joins two strings. Immediate if (iif) function (iif(condition,true-value,false-value)) a function used in a calculated field or control which returns one value if the condition is true and another value if it is false. Isnull function function which returns true if a field is null (has no value), otherwise returns a false.
