Microsoft KB Archive/209084

= ACC2000: Previewing Records That Will Be Affected by Action Query =

Article ID: 209084

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209084



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

This article applies only to a Microsoft Access database (.mdb).



SUMMARY
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.

