Alison Balter's Mastering Access 2002 Enterprise Development

Working with Computed Columns

With computed columns, you can create a column that is based on data in other columns. SQL Server automatically updates the computed column when the columns that it depends on are updated. An example is an extended total that you base on the product of the price and quantity columns. To create a computed column, simply enter the desired formula into the Formula property of the column (see Figure 5.11).

Figure 5.11. To create a computed column, simply enter the formula into the Formula property of the column.

[View full size image]

Table 5.5 shows examples of computed columns.

Table 5.5. Examples of Computed Columns ...