O'Reilly logo

Introducing Microsoft® Office InfoPath™ 2003 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

Displaying Running Sums in an Expression Box

One of the fundamental rules of database design is to eliminate storing in tables duplicate data or information that’s calculated from database column values. Using the NorthwindCS database as an example, storing the extended net amount of an Order Details record in an Extended column requires updating the Extended value whenever the Quantity or Discount values change. Similarly, storing the sum of Extended values as the total order amount—less freight, taxes, and other charges—requires recalculating this value each time an Extended value changes or line items are added to or deleted from the order. The most common practice is to create views or stored procedures that provide calculated values. Views ...

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