Getting started with Access tutorial 10.3 common symbols in expression Builder

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.