To sort the rows of the result of the query:
Click on the row Order: from the field by which we sort the rows, do
click the arrow that appears to display the list and select the sort order.
can be Ascending in this case will be ranked lower higher if the field is numeric ,
alphabetical order if the field is of type text , anterior to posterior if the field is of type date / time, etc ..., or it may be Descending in reverse order.
can also order by multiple fields to fill in this row Order: of all the columns we want to sort.
In this case the rows are sorted by the first sort column, for the same value in the first column is sorted by the second column, and so on.
The order of the columns of organization is what appears in the grid, ie if we sort by example by province and within the same province and city have to take the first grid column after column province and locality.
The type of organization is independent so you can use a different sort for each column. For example up by the first column and into the first column, descending the second column.
Select rows
input
To select rows have to specify a search criteria, a search criterion is a condition that must comply with all the rows that appear in the query result.
Usually the condition will be based on table field.
When the condition is an equality is not necessary to put the = sign, we can directly put the value in the Criteria row. Nor is it necessary to put the quotes, the default added. Whenever there is a text enclose it in quotes.
If the Criteria row, we want to put a field name instead of a value (to compare two fields together, we must enclose the field name in brackets [].
* To specify multiple conditions are used operators Y and O:
"In a search criterion that conditions are attached by the operator And , so the record appears to be met all conditions.
"In a search criterion that conditions are attached by the operator O , the record will appear in the query result if it meets at least one of the conditions.
All conditions set out in the same row of the grid are joined by the operator Y.
Just about every one of the rows O: If we want the conditions are united by the operator O we have to put them in separate rows (using the ranks O: et seq.)
Note: Access not case sensitive when to search for records.
Conditions: Here we detail the various operators that can be used in a condition.
comparison operators: These operators compare the value of an expression with the value of another. Regardless of the operator if one of the values \u200b\u200bis null, the comparison result is null (neither true nor false).
operator Among
has the following syntax:
Expression Between value1 And value2
examines whether the value of the expression is between two defined values \u200b\u200bvalue1 and value2. Normally the expression is a field name.
In operator
has the following syntax: Expression
In (value1, value2, ...)
examines whether the value of the expression is one of the securities included in the list of values \u200b\u200bwritten in parentheses.
0 comments:
Post a Comment