What is the difference between simple criteria and multiple criteria in ms access 2007
Answers
Answer:
Open the table that you want to use as your query source and on the Create tab click Query Design.
In the Query Designer, select the table, and double-click the fields that you want displayed in the query results.
Add your first criterion in the Criteria row.
Note: Use the appropriate column, we’ve used the Country/Region in this example but if you want to locate specific last names, you’d add the criteria in the Last Name field.
Add the alternate criteria in the or row and if you have more than one use the empty rows below, and click Run.
Press CTRL+S to save the query.
Explanation:
please mark me as Brainlist
Answer:
When you use multiple rows for criteria, the expressions on each row are treated as though they are joined by AND, but each row's worth of criteria are treated as though they are joined by OR. Access first looks at one row of criteria and finds all the records that meet all the criteria on that row.
Explanation:
mark me brainist