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

3.8 ★ | 4 Vote

May be interested

  • Create and edit mathematical expressions in ExcelCreate and edit mathematical expressions in Excel
    show you how to create and edit mathematical expressions in excel. to insert mathematical formulas, you perform the following steps: step 1: go to the insert - text - symbols - equation tab: step 2: the dialog box contains the display formula types - select the formula type
  • Insert and edit mathematical expressions in WordInsert and edit mathematical expressions in Word
    introduce how to insert and edit mathematical expressions in word. step 1: go to insert - text - equation tab - select the mathematical expression to create.
  • Common calculation functions in ExcelCommon calculation functions in Excel
    excel is a spreadsheet that supports functions that help you in the process of calculating and processing data, if you know the calculation functions, how to use them, your work will be processed more quickly.
  • Prepare and edit mathematical expressions in WordPrepare and edit mathematical expressions in Word
    to create beautiful and standard mathematical formulas, you use the equation feature in word. how to create and edit mathematical expressions in word. step 1: to create mathematical formulas, you go to the insert - symbol - equation tab - you can create by using existing templates or click.
  • Calculation of percentages in ExcelCalculation of percentages in Excel
    calculating percentages in excel is a basic calculation, with a very simple and quick calculation when you don't need to enter any functions.
  • Quick and standard percentage calculation (%)Quick and standard percentage calculation (%)
    during the sales process, you can use excel to inventory goods and take advantage of this calculation method to calculate the discount percentage for your item as quickly and correctly as possible. let's tipsmake.com learn how to calculate the percentage (%) of the fastest and most standard discount.
  • Instructions for calculating total lines and columns in Word 2013Instructions for calculating total lines and columns in Word 2013
    if you are working in word and need to calculate the value of an expression, you can do simple calculations such as summarizing, multiplying, and calculating the average value on the word without copying. data into excel to calculate and paste the results into word.
  • How to use subtraction in ExcelHow to use subtraction in Excel
    subtraction in excel is a basic calculation, which is used a lot in excel calculation exercises.
  • Science reveals 5 simple ways of detecting liesScience reveals 5 simple ways of detecting lies
    with 5 ways to be scientifically proven below, you can rely on expressions of words and expressions to detect a person who is lying. especially the last way can detect liars to 99% accurate.
  • 5 useful online calculation tools for life5 useful online calculation tools for life
    here are 5 useful and wonderful online calculation tools that can help you control your own time, habits, sleep and life.