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

