Run a query (MDB)

When you open a select or crosstab query, Microsoft Access runs (executes) the query for you and shows the results in Datasheet view.

1. In the Database window, click Queries under Objects.
2. Click the query you want to open.
3. Click Open on the Database window toolbar.

Unlike select and crosstab queries, you can't view the results of an action query by opening it in Datasheet view. However, in Datasheet view you can preview the data that will be affected when you run the action query.

Caution   It's a good idea to make a copy of the data you are changing or moving in an action query, in case you need to restore the data to its original state after running the action query.

1. Open the action query in Design view.
2. To preview the records that will be affected in Datasheet view, click View on the toolbar and check the records. For each action query, you will see the following:

   For this query	The datasheet displays
   Update	The fields to be updated.
   Delete	The records to be deleted.
   Make-table	The fields to be included in the new table.
   Append	The records to be added to another table.

3. To return to query Design view, click View on the toolbar again. Make any changes you want in Design view.
4. Click Run on the toolbar to run the query.

Note  To stop a query after you start it, press CTRL+BREAK.