ACC: Previewing Records That Will Be Affected by Action Query

• Microsoft Access versions 2.0, 7.0, 97

SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

An action query modifies data or copies data from one table to another. An action query does not produce a recordset of the completed action that you can view in Datasheet view. To view the results of an action query, you must open the table that the action query affected. You can, however, preview the records that will be selected by an action query. To do this, open the action query in Design view, and then click the Datasheet View button on the toolbar.

The following table lists what will be shown in Datasheet view for various types of queries:

   Query Type     The Datasheet Displays
   -----------------------------------------------------------------
   Update         The fields to be updated with their current value, not
                  the new value.
   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.

REFERENCES