Calculated
Fields in Queries
In a query,
it is possible to take fields from other tables and/or queries
and make a new field that calculates those fields in some
manner. For example, you can create a field that would take
a list of product prices and increase them by 10%.
Notice
the fourth column. It is a new field, called New Price, where
the amounts in the Price field are multiplied by 1.1, which
will raise each price 10%. Here is the result when the query
is run.
For more
complicated formulas, you can use the Expression Builder,
which can be opened by right-clicking on the new field in
the QBE grid and choosing Build... from the shorcut menu.
|
