␡
- What Is a Query and When Should You Use One?
- Opening a Query in Datasheet View
- Opening a Query in Design View
- Running a Query
- Adding and Removing Fields
- Modifying the Sort Order of a Query
- Working with Simple Criteria
- Modifying the Datasheet View of a Query
- Saving a Query
- Printing Query Results
- Closing a Query
- Summary
- Q&A
- Workshop
This chapter is from the book
Opening a Query in Datasheet View
When you're working with an existing query, you need to be able to open it in Datasheet view. Here are the steps in involved:
Select Queries in the list of objects in the Database window.
-
Click to select the query that you want to run, and then select Open on the Database window toolbar or double-click the query to run it. The result of the query appears in Datasheet view (see Figure 3.1).
Figure 3.1 The Current Product List query in Datasheet view.