Ms Access 2010 tutorial:field calculation


Field calculation

VI. Field Calculation

You can make calculation on fields of a query such as addition, subtraction, multiplication, and division.

Example1: Calculate sub total by multiplying quantity field with unit price field of TblProduct as the figure below:

SubTotal:Quantity*UnitPrice

Microsoft Access 2010 calculate on field 

Result:

Microsoft Access 2010 calculate on field result   

Example2: You want to display Khmer currency automatically in the Khmer field when you enter Dollar currency in the Dollar field. To do that follow the figure below:

Microsoft Access 2010 using multiplication 

Note: If you want to display any currency that you want, format it in the Format property of the Property Sheet.




Comments




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.