Microsoft Office Tutorials and References
In Depth Information
Using Access Data in a Word Document
3. Click Service i n the Available Fields list box, click the > button, click HowOftenRequested
in the Available Fields list box , and then click the > button to add those columns to the
Selected Fields list box.
4. Click the Next button.
In the second dialog box of the wizard, you choose whether you want to view detail or sum-
mary information. Detail view shows every field of every record. To show a summary, you first
choose how to summarize the information. For example, you could show the sum total of all
the services requested instead of individual records. In this case, you need to show every field.
5. Click the Next button to accept the default of showing detail information. In the final dia-
log box of the wizard, you provide a title for the query. Access shows “Services Requested
Query” for this query.
6. Click the Finish button to accept Services Requested Query as the query name. The query
results appear in a datasheet.
7. Double-click the right column border on the Service column to expand the column to fit all
of the entries, and then do the same to the second column. See Figure 2-13.
Results of the Services Requested Query
These results show all of the services requested. To set criteria to show only services
requested more than 1500 times, you have to switch to Design view.
8. On the Query toolbar, click the View button . The query switches to Design view.
You need to set criteria to select only those records where the number of requests is greater
than 1500. Although you need the HowOftenRequested field to select records based on that
information, you don’t want to show this field in the datasheet, only the Service Requested
field. You can hide the HowOftenRequested field so it doesn’t appear in the query results.
9. Click in the Criteria row of the HowOftenRequested column, and then type >1500 .
10. Click the Show check box in the HowOftenRequested column to clear it. This hides the
quantity information in the results. See Figure 2-14.