Exploring Queries 775
- In the Delete Discontinued Products Properties dialog box, click Cancel.
- Right-click the Products By Category query, and then click Open.
Access runs the query.This datasheet displays the results of running the Products By Category query.The record navigation bar indicates that 171 records are displayed; the Products
table actually contains 189 records. To find out why 18 of the records are missing,
you need to look at this query in Design view.- On the View Shortcuts toolbar, click the Design View button.
Access displays the query in the Query Designer, and the Query Tools Design
contextual tab appears on the ribbon.