Database Reference
In-Depth Information
To enter a criterion for a field, include the field in the design grid, and then enter the criterion in the
row labeled
Criteria
for that field, as shown in Figure 2-7.
38
Criterion causes
the query to select a
record only when the
CustomerNum is 148
FIGURE 2-7
Query to find the name of customer 148
NOTE
When you enter a criterion for a Text field, such as CustomerNum, Access automatically adds double quotation marks around
the value when you run the query or move the insertion point to another box in the design grid. Typing the quotation marks is
optional. (Some DBMSs use single quotation marks to enclose Text values.)
Q&A
Question: Why is the CustomerNum field a Text field? Doesn't it contain numbers?
Answer: Fields such as the CustomerNum field that contain numbers, but are not involved in calculations,
are usually assigned the Text data type.
Search WWH ::




Custom Search