Access Tip of the Day
Double-check which records an action query will impact (Access 97/2000/2002)
When you're working with SELECT queries, you probably click the Run button (!) when you want to check results. Force of habit may cause you to also use the Run button when working with action queries, like UPDATE or DELETE queries. Of course, this results in a warning asking if you really want to proceed. Since you probably want to look before you leap, you may reconfigure your query as a SELECT query, check the records returned, and then revert back to the action query. All of this work is unnecessary if you remember an often overlooked or forgotten capability.
When you want to check the records that will be impacted by an action query, simply click the View button instead of Run. As an alternative, you can also choose View | Datasheet View from the menu bar. You'll see which records will be affected in a standard datasheet. From that point, you can return to Design view to either run the query or make additional changes to ensure that you get exactly the results you're looking for.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2025 MJ Technologies, LLC. All rights reserved.