Database Reference
In-Depth Information
37
Asterisk in the
Orders table
field list
Asterisk indicates
that all fields will
be included in the
query results
FIGURE 2-5
Query that includes all fields in the Orders table
The query results appear in Figure 2-6.
All fields in
the Orders table
are included
FIGURE 2-6
Query results
SIMPLE CRITERIA
When the records that you want to display in a query
s results must satisfy a condition, you enter the condi-
tion in the appropriate column in the design grid. Conditions that data must satisfy are also called criteria.
(A single condition is called a criterion.) The following example illustrates the use of a criterion to select data.
'
EXAMPLE 3
Find the name of customer 148.
