Microsoft Office Tutorials and References
In Depth Information
=
Records of which the key is completely blank.
<>
Records that contain any nonblank entry.
Records that contain the single character C. You enter this exactly as shown:
as a formula, with an initial equal sign. Alternatively, you can use a leading
apostrophe and omit the quotes:‘=c
="=c"
The text comparisons are not case sensitive. For example, se* matches Seligman,
seller, and SEC.
Specifying multiple criteria
Often, you may want to select records based on criteria that use more than one field or multiple values within a
single field. These selection criteria involve logical OR or AND comparisons. Here are a few examples of the
types of multiple criteria that you can apply to the real estate database:
• A list price less than $250,000, and square footage of at least 2,000
• A single-family home with a pool
• At least four bedrooms, at least three bathrooms, and square footage less than 3,000
• A home that has been listed for no more than two months, with a list price greater than $300,000
• A condominium with square footage between 1,000 and 1,500
• A single-family home listed in the month of March
To join criteria with an AND operator, use multiple columns in the criteria range. Figure 9-20 shows a criteria
range that filters records to show those with at least four bedrooms, more than 3,000 square feet, and a list price
of $390,000 or less.
Figure 9-20: This criteria range uses multiple columns that select records using a logical AND operation.
Search JabSto ::




Custom Search