Page 337 - TP_IT_V1.0_C10_flipbpookl
P. 337

The query opens in a Query Design window where you can make the required changes.
                 Step 4:  Modify the query according to your requirement
                 Step 5:  Click on the Save button in the Query Design toolbar.





















                 Now if you run the query, you will get the different output.














                 Setting Multiple Fields Criteria
                 Perform the following steps to use multiple field criteria:

                 Step 1:  Create a query in design view.
                         The Query Design window open with the Add Table or Query dialog box.
                 Step 2:  Add the table you wish to use in the query as Marks table.
                 Step 3:  Click the Close button in the Add Table or Query dialog box.
                 Step 4:  Add fields for query.

                 Step 5:   Set the criteria in different fields. In this case, we have set the criteria in two fields: Total Marks > 375
                         Percentage < 90.




























                                                                        Database Management System using LibreOffice Base  335
   332   333   334   335   336   337   338   339   340   341   342