CPSC-2200 Lecture Notes - Lecture 3: Iif, Logical Connective, Railways Act 1921

41 views6 pages

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.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents