Expression in Access: Calculation Expressions in Access 2016

This updated guide examines Expression in Access: Calculation Expressions in Access 2016 and organizes the essential facts, background, and practical takeaways in clear American English.

Expressions used to perform various tasks. In this article, TipsMake.com will guide you to create a specific type of expression called a calculation expression . We will create calculated fields and display data that is not available in the database that is calculated from the stored individual fields.

To illustrate, we use information from many different tables: tblKhachhang, tblSach, tblDonhang, tblChitietdonhang .

Run the query and you will see the following results.

Now we try to perform a simple calculation, taking the number of books placed multiplied by the selling price of one book to get the total amount to be paid. We call this field Total money.

Full expression:

Tongtien: [tblChitietDonhang]![Soluong]*[tblSach]![GiaChitiet]

Running the query, you can see that Tongtien field appears at the end.

Add a tax calculation column :

Thue: [Tongtien]*0.1

Run the query yourself and see the results in the last column.

Previous lesson: Wildcard representation operator in Access

Next lesson: Wildcard representation operator in Access