Share this Page URL

Chapter 9. Extending Your Use of Queries > Running Action Queries - Pg. 315

Extending Your Use of Queries 315 3. In the Update To row for the field CampaignBudget, enter the following expression: [CampaignBudget]*1.15 4. 5. In this example, we're updating one field. You can update more than one field with a single update query. On the toolbar, click the View button to see the query in Datasheet view. The datasheet shows which records will be updated. In this case, that's all the records in the table. Click the View button again to switch back to Design view. On the toolbar, click the Run button.