• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. What Every Developer Needs to... > Understanding How You Can Update Que...

Understanding How You Can Update Query Results

If you haven't realized it yet, you can usually update the results of your query. This means that if you modify the data in the query output, the data in the tables underlying the query is permanently modified.

Build a query based on the Customers table. Add the CustomerID, CompanyName, Address, City, and Region fields to the query design grid; then run the query. Change the address of a particular customer, and make a note of the customer ID of the customer whose address you changed. Make sure you move off the record so that Access writes the change to disk. Close the query, open the actual table in Datasheet view, and find the record whose address you modified. Notice that the change you made was written to the original table—this is because a query result is a dynamic set of records that maintains a link back to the original data. This happens whether you're on a standalone machine or on a network.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint