Chapter 10. Understanding Jet Operators and Expressions
In this chapter
Writing Expressions for Query Criteria and Data Validation
Understanding the Elements of Expressions
Operators
Literals
Identifiers
Functions
Intrinsic and Named Constants
Creating Jet Expressions
Troubleshooting
In the Real World—The Algebra of Access Expressions
Writing Expressions for Query Criteria and Data Validation
Chapter 6, “Entering, Editing, and Validating Jet Table Data,” briefly introduced you to operators and the expressions that use them when you added validation rules to table fields. Chapter 9, “Designing Queries for Jet Databases,” touched on expressions again when you devised selection criteria for the query that you created. Expressions play an important role in all ...
Get Special Edition Using Microsoft® Office Access 2003 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
