Calculation expressions in Access 2016

Expressions in MS Access can be understood similarly to formulas in Excel. Expressions can include operators, constants, functions, and identifiers.

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 .

Calculation expressions in Access 2016 Picture 1

Run the query and you will see the following results.

Calculation expressions in Access 2016 Picture 2

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] 

Calculation expressions in Access 2016 Picture 3

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

Calculation expressions in Access 2016 Picture 4

Add a tax calculation column :

 Thue: [Tongtien]*0.1 

Calculation expressions in Access 2016 Picture 5

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