Design View window appears query:
If you look at the screen on the top we have the tables area which contains the tables appended to their corresponding fields, and at the bottom called QBE grid defined the query.
Each column in the QBE grid corresponds to a field.
Each row has a purpose as detailed briefly below:
Country
That put the field to use in most cases will display the field may be the name of a table field and can also be a calculated field. Table
name of the table from which we draw the field. Will be useful when we define queries based on multiple tables.
Order
can sort the rows of the result.
Show
If the checkbox is disabled the column does not appear in the result, it is usually clear when we use the field to define the query but do not want to appear in the result.
Criteria Used to specify a search criteria. A search criterion is a condition to be met by records that appear in the query result.
therefore consists of a condition or several conditions attached by the operators Y (AND) and O (OR). O: this row and the following conditions are used to combine.
If you look at the screen on the top we have the tables area which contains the tables appended to their corresponding fields, and at the bottom called QBE grid defined the query.
Each column in the QBE grid corresponds to a field.
Each row has a purpose as detailed briefly below:
Country
That put the field to use in most cases will display the field may be the name of a table field and can also be a calculated field. Table
name of the table from which we draw the field. Will be useful when we define queries based on multiple tables.
Order
can sort the rows of the result.
Show
If the checkbox is disabled the column does not appear in the result, it is usually clear when we use the field to define the query but do not want to appear in the result.
Criteria Used to specify a search criteria. A search criterion is a condition to be met by records that appear in the query result.
therefore consists of a condition or several conditions attached by the operators Y (AND) and O (OR). O: this row and the following conditions are used to combine.
0 comments:
Post a Comment