When many criteria lines are used for a filter, they are connected by AND or OR logic. The Quick filter allows you to connect criteria lines using only AND. The Advanced Filter dialog box allows you to combine AND and OR logic.
Records meet every condition (AND)
Find records for all stop signs that are high-intensity sheeting material. The records on the filtered list go through two selection processes that occur one after the other. The first selects records if they have the MUTCD Code for stop signs (R1-1). The stop sign records are then selected based on the sheeting material.
Records meet any condition (OR)
Find records for stop signs or merge signs. The records on the filtered list go through two selection processes, but this time the selection processes are independent of each other. The first selects records if they have the MUTCD Code for stop signs (R1-1); the second selection chooses records that have the MUTCD Code for merge signs (W4-1). The filtered list includes both sets of records.