• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Understanding Jet Operators ... > Writing Expressions for Jet Queries ...

Writing Expressions for Jet Queries 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 roll in all the chapters that follow.

Much of this chapter is devoted to describing the VBA functions available to Jet 4.0 for dealing with data of the Numeric, Date/Time, and Text field data type. Functions play important roles in every element of Access, from validation rules for tables and fields of tables to the control of program flow with VBA. You use functions when creating queries, forms, reports, and even more extensively when writing VBA and VBScript code. To use Access 2002 effectively, you must know what functions are available to you and how to use functions and operators effectively.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint