Page 56 - TP_Prime_V2.2_Class8
P. 56

Creating a Query

                  To create a query, follow these steps:

                  Step 1:  Click on Query Design command from Queries group under Create tab.



           Prime (Ver. 2.2)-VIII  Step 2:  The Show Table dialog box will open. Select the desired table and click on the



                                                            Creating a Query



                            Add button.

                  Step 3:  Add the field's name to the query window and specify the criteria.




          54
















                                                          Defining Query Criteria

                  The parameters of the design grid in the bottom part of the Query window are:

                  •  Field: It displays the selected field names from the table or query.

                  •  Table: It displays the name of the existing tables in the relationship window.

                  •  Show: This means that the field with the check mark will be displayed in the result and
                     the fields with an uncheck mark will not be displayed when the query runs.

                  •  Sort: It displays the data in either descending or ascending order during the run
                     time.

                  •  Criteria: This displays the condition on the basis of which the records will be filtered

                     and displayed in the query output.

                  •  Or: It is used to set multiple conditions in a query.
                  After creating the query, we need to run the query by clicking on the Run button                    .

                  The related records of the query will be displayed in the Datasheet view.
   51   52   53   54   55   56   57   58   59   60   61