Question

how do you apply multiple criteria to the same table ? Explain with an example .​

Answer 1

Answer:Multiple criteria can be added on a table÷

1. When you type two criteria on the same line, only records where both criteria are met will be displayed. This is called AND condition.

2. When you type first criterion on the Criteria row and the second criterion on the Or row, the records where either criteria are met will be displayed. This is called OR condition.