Queries Key Terms

Queries

Criteria	When you want to limit the results of a query based on the values in a field, you use query criteria. A query criterion is an expression that Access compares to query field values to determine whether to include the record that contains each value.
Sort	Sorting means organizing records in a meaningful way so that you can retrieve data faster and in an order of your choice. For example, if you want to view records in the ascending order of the last name of volunteers, you can sort the records based on the values in the last name field.
[Field Name]	In query, Field Name is written inside bracket [ ]
Arithmetic operators	You use the arithmetic operators to calculate a value from two or more numbers or to change the sign of a number from positive to negative or vice versa.
Logical Operator	You use the logical operators to combine two Boolean values and return a true, false, or null result. Logical operators are also referred to as Boolean operators.
Value	the numerical amount denoted by an algebraic term; a magnitude, quantity, or number.
Function	functions must be expressed as function calls (e.g. sum(a,b) instead of a+b) See more on: http://wiki.apache.org/solr/FunctionQuery#What_is_a_Function.3F