Filtering records with conditions

Copies >= 4 means Copies is greater than or equal to 4. Does a record with exactly 4 copies satisfy it?

Use the equality part of the supplied symbol meaning

Filtering keeps a selected view

These synthetic asset records have one record per row and one field per named column

A filter condition is a true-or-false test applied to each record. The result contains every record that passes

Here, > means greater than, >= means greater than or equal to, < means less than, <= means less than or equal to, and = means equal to

The complete result may contain several records, all records or no records. Select all matching codes, not just the first match

Check every row

Use this complete synthetic asset table. Filtering selects matching records without changing stored values or deleting other records

Condition: Copies >= 2

>= means greater than or equal to

Keep a record exactly when its stated condition is true

Select every matching asset code. If none match, select No records on its own

A07: Copies is 2, so Copies >= 2 is true; include this record

B12: Copies is 5, so Copies >= 2 is true; include this record

C04: Copies is 1, so Copies >= 2 is false; exclude this record

D19: Copies is 4, so Copies >= 2 is true; include this record

The matching records are A07, B12, D19

A strict comparison changes the result

Keep the exact match

A query can have no matches

AND requires both tests in the same row

For two conditions joined by AND, a record is included only when both conditions are true for that record

Do not borrow one true result from one record and another true result from a different record

A record with one true and one false result does not satisfy AND

Test both named fields

Use this complete synthetic asset table. Filtering selects matching records without changing stored values or deleting other records

Condition: Copies >= 2 AND Loan days <= 7

>= means greater than or equal to; <= means less than or equal to

AND keeps a record only when both conditions are true for that same record

Select every matching asset code. If none match, select No records on its own

A07: Copies is 2, so Copies >= 2 is true; Loan days is 7, so Loan days <= 7 is true; include this record

B12: Copies is 5, so Copies >= 2 is true; Loan days is 14, so Loan days <= 7 is false; exclude this record

C04: Copies is 1, so Copies >= 2 is false; Loan days is 3, so Loan days <= 7 is true; exclude this record

D19: Copies is 4, so Copies >= 2 is true; Loan days is 10, so Loan days <= 7 is false; exclude this record

The matching records are A07

Keep every record that passes both

This truth table uses the fixed conditions Copies > 4 and Loan days < 10 for the four asset records. A 1 means true or selected; 0 means false or not selected. Compare AND, which requires both, with inclusive OR, which requires at least one. Predict the selected count before changing the rule

With OR selected, why is D19 still excluded?

OR includes one or both

Inclusive OR keeps a record if at least one condition is true. A record that passes both is included once, not excluded or counted twice

Only a record with both conditions false is excluded by OR

The joining rule belongs to the query. Changing AND to OR can change the result without changing any stored field values

A match can come from either condition

Use this complete synthetic asset table. Filtering selects matching records without changing stored values or deleting other records

Condition: Copies < 2 OR Loan days > 10

< means less than; > means greater than

OR is inclusive: keep a record when at least one condition is true, including when both are true. Include each matching record only once

Select every matching asset code. If none match, select No records on its own

A07: Copies is 2, so Copies < 2 is false; Loan days is 7, so Loan days > 10 is false; exclude this record

B12: Copies is 5, so Copies < 2 is false; Loan days is 14, so Loan days > 10 is true; include this record

C04: Copies is 1, so Copies < 2 is true; Loan days is 3, so Loan days > 10 is false; include this record

D19: Copies is 4, so Copies < 2 is false; Loan days is 10, so Loan days > 10 is false; exclude this record

The matching records are B12, C04

The complete result can include every record

A record matching both is still one record

Selection is not deletion

These tasks select a result from a complete supplied table. Records outside the result are still stored

Changing a filter can reveal a different set of existing records without editing their values

The saved table has A07 with 2 copies, B12 with 5, C04 with 1 and D19 with 4. The table is unchanged. A filter is changed from Copies > 5 to Copies >= 4, so B12 and D19 now appear. What happened to those records?

The stated action changes selection, not storage

Test each record and keep the complete set

Use the named field and the exact comparison, including whether equality is allowed

Apply every condition within the same record. AND needs both; inclusive OR needs at least one

Include each matching record once. No matches, one match, several matches and all matches are all possible

Selecting a view does not by itself create, edit or delete stored records