Getting started with Access tutorial 10.3 common symbols in expression Builder

Source: Internet
Author: User
What are the functions of these shortcut buttons on expression builder? The symbols "+", "-", "*", and "" represent four operators in mathematical operations: "plus", "minus", "multiplication", and "division ".. The "" symbol can be used to force the two expressions to be connected together. For example, the Database User Guide will return: database usage

What are the functions of these shortcut buttons on expression builder? The "+", "-", "*", and "/" symbols represent four types of mathematical operations: "add", "Subtract", "Multiply", and "divide ". operation symbol. The "" symbol can be used to force the two expressions to be connected together. For example, the Database User Guide will return: database usage


ExpressionGeneratorWhat are the functions of these shortcut buttons on?

"+", "-", "*", And "/"SymbolIt represents four types of operations in mathematical operations: "plus", "minus", "multiplication", and "division ".Symbol. Use "&"SymbolTwoExpressionForce join together. For example, "Database" & "User Guide" will return: "Database User Guide", that is, connect these two strings together, and the left string is in front, the right side of the string is behind. As shown in.

Getting startedTutorial10.3ExpressionGeneratorCommonSymbol"/>

"=", ">", "<", And "> <>"SymbolThey indicate "equal", "greater than", "less than", and "not equal", respectively. They are used to determine whether a condition is met. For example: "= 34" indicates that a value equal to 34 meets this condition. "<>" Beijing "" indicates that the condition is met when a value is not equal to the string "Beijing.

The logical operators "And", "Or", And "Not" are used to connect the preceding conditions.Expression. For example, "> 100 And <300" indicates that the original computing condition is met only when a value is greater than 100 And less than 300; "> 100 Or <300" indicates that the value must be greater than 100 Or less than 300. In fact, any number meets this condition. "Not> 100" indicates thatExpressionIt indicates that the condition is met as long as the value is not greater than 100.

There is also a "Like", thisSymbolHow to use it? ThisSymbolIt is often used to perform logical judgment on a struct value, and whether the value meets a certain format type. Therefore, "Like" is not used independently.Symbol: "?" Represents any single character; "*" Represents zero or multiple characters; "#" represents any number; "[Character List]" represents any single character in the character list; "[! Character List] "indicates any single character that is not in the character list. Let's take a look at several examples: Like "China? "The strings" Chinese "and" Chinese "all meet this condition; like "China *", the strings "China", "Chinese", and "People's Bank of China" all satisfy this condition; if you Like "table #", the strings "table 1" and "Table 2" meet this condition. Like "[Beijing, Shanghai, guangzhou] "only strings" Beijing "," Shanghai ", and" Guangzhou "can meet the conditions. Like "[! Beijing, Shanghai, Guangzhou] "only strings" Beijing "," Shanghai ", and" Guangzhou "cannot meet the conditions.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.