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

Operators

Access and VBA provide six categories of operators that you can use to create expressions:

  • Arithmetic operators perform addition, subtraction, multiplication, and division.

  • Assignment and comparison operators set values and compare values.

  • Logical operators deal with values that can only be true or false.

  • Concatenation operators combine strings of characters.

  • Identifier operators create unambiguous names for database objects so that you can assign the same field name, for example, in several tables and queries.

  • Other operators, such as the Like, Is, In, and Between operators, simplify the creation of expressions for selecting records with queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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