access+course+training - How best to use the "expression" tool in queries

Ainul

The "Expression" tool accessed by the Build button is very useful to create (build) Calculations and Formulas in the query, using both normal syntax and Functions.

For example

In a Query listing all the Orders received a field can be created to calculate the Total value of the order by :

Multiplying the Amount Ordered by the Unit Price

Regards

Carlos