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 — Use information from many different tables: tblKhachhang, tblSach, tblDonhang, tblChitietdonhang

Run the query and you will see the following results.

Calculation expressions in Access 2016 Picture 2 — Results when running the above query

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 — Create expressions in the new Tongtien field

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

Calculation expressions in Access 2016 Picture 4 — There are rows Total money is the result of 2 columns Soluong and GiaChitiet

Add a tax calculation column :

 Thue: [Tongtien]*0.1

Calculation expressions in Access 2016 Picture 5 — Add tax equal to 10% of the total amount

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

Marvin Fry

Update 21 June 2019

You should read it

May be interested

Relationships between tables in Access
in this article, go with tipsmake.com to learn more about how to establish a relationship. the nn relationship is the relation between two tables, a record of table a can have multiple records matching in table b and vice versa.
How to delete personal information from PowerPoint presentations before sharing
office applications can store personal information in every file you create, meaning that all recipients of that file will have your information.
Wildcard representation operator in Access
wildcard, also known as a wildcard, can be used to determine the location of a specific item when you don't remember exactly how it was written.
1-n relationship between tables in Access
the 1-n relationship is the type of relationship in which a record in the table may have multiple matching records in another table, but a record in the second table only has one matching record in the first table.
1-1 relationship between tables in ACCESS
1-1 relations are used to link a record from one table to one and only one record in another table.
Establish relationships between tables in Access 2016
in this article, tipsmake.com will work with you to learn the necessity of creating relationships between related tables. the relationship between tables is the data link between tables.

Calculation expressions in Access 2016

You should read it

May be interested

Office information