Page 283 - IT 402 v2.0 class 10
P. 283
Step 4: The query opens in a new window where you can make the required changes. In this case, we have
modified the existing condition > ‘400’ to < ‘400’.
Step 5: Click on the Save button in the Standard toolbar.
5
4
Step 6: Now if you run the uery you will get the different output.
Setting Multiple Fields Criteria
erform the following steps to use multiple field criteria:
Step 1: reate a uery in design view based on the following table:
Step 2: Set the criteria in different fields. In this case we have set the criteria in two fields.
Database Management 281

