O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Updating Values of Multiple Records in a Table

Update queries change the values of data in a table. Such queries are useful when you must update field values for many records with a common expression. For example, you might need to increase or decrease the unit prices of all products or products within a particular category by a fixed percentage.

To see how an update query works, you perform some of the housekeeping chores discussed earlier in the chapter that are associated with using the tblShipAddresses table. To implement this example, you must have created the tblShipAddresses table, as described in the Creating New Tables with Make-Table Queries section earlier in this chapter. You also must modify the tblOrders and tblShipAddresses tables ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required