Microsoft Office Tutorials and References
In Depth Information
Session 3.2
Figure 3-23
Datasheet after changing font size and column widths
Trouble? Your screen might show more or fewer columns, depending on the monitor you
are using.
10. Save and close the query. You return to the Database window.
After viewing the query results, Matt decides that he would like to see the same fields,
but only for those records whose Wage field value is equal to or greater than 17.00. He
needs this information when he recruits students who require a higher wage per hour for
the available positions. To create the query needed to produce these results, you need to
use a comparison operator to match a range of values—in this case, any Wage value
greater than or equal to 17.00.
Using a Comparison Operator to Match a Range of Values
Once you create and save a query, you can click the Open button to run it again, or you
can click the Design button to change its design. Because the design of the query you
need to create next is similar to the July1Positions query, you will change its design, run
the query to test it, and then save the query with a new name, which keeps the
July1Positions query intact.
To change the July1Positions query design to create a new query:
1. Click the July1Positions query in the Database window (if necessary), and then click the
Design button to open the July1Positions query in Design view.
2. Click the Wage Criteria text box, type >=17 , and then press the Tab key three times. See
Figure 3-24.
Figure 3-24
Changing a query’s design to create a new query
condition to
delete
new condition
Matt’s new condition specifies that a record will be selected only if its Wage field value is
17.00 or higher. Before you run the query, you need to delete the condition for the
StartDate field.
 
Search JabSto ::




Custom Search