You can select all or part of a value in a field. How you select the value determines what records the filter returns.
Selecting | Finds records in which | Example |
---|---|---|
The entire contents of a field (or placing the insertion point in a field without selecting anything) | The entire contents of that field matches the selection. | You select the value "Berlin" in the City field. The filter returns all records with Berlin as the city. |
Part of a value starting with the first character in a field | The value in that field starts with the same characters you selected. | In the CompanyName field containing the value "France restauration," you select only "Fran." The filter returns all records that have a company name starting with "Fran," such as Franchi S.p.A. and Frankenversand. |
Part of a value starting after the first character in a field | All or any part of the value in that field contains the same characters you selected. | In the CompanyName field containing the value "Old World Delicatessen," you select the letters "Del." The filter returns all records that have "del" anywhere in the CompanyName field, such as Ernst Handel, Galería del gastrónomo, and Que Delícia. |