View the results of a select or crosstab query

View the results of a select or crosstab query

Microsoft Access displays the results of a select or crosstab query in a datasheet. You can display the datasheet from query Design view or by clicking Open on the Database window toolbar.

From Do this
Query Design view Click View on the toolbar.
Database window Click Queries under Objects, and then double-click the query name, or select the query and then click Open on the Database window toolbar.

To stop the query, press CTRL+BREAK. (This procedure may not work for very large queries, however.)