Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130
. Run the query to view the results.
1 answer:
Answer:
>120 and <130
Microsoft Access uses "and" to combine queries, enabling you to view more defined entries in a column. Queries have to be modified from the design view.
Explanation:
Open the existing query. You can find this by choosing "All Access Objects". The query opens in the datasheet view so click on the view button to change it to the design view.
Go to the bottom pane, In the "Fields" row, select Credits and in "Criteria" row, enter the following: >"120" And <"130"
You can also type >120 and <130
Click on the design tab and then click Run!
The query will display all the values greater than 120 and less than 130 in the Credits row.
You might be interested in