Microsoft Access 2007 tutorial: field calculation

Field Calculation

VI. Field Calculation

You can calculate on fields of a query such as addition, subtraction, multiplication, division and so on. For instance, calculate sub total by multiplying quantity field and unit price field as figure below.


Microsoft Access 2007 Calculate Sub Total

One more example is that you want to create a query that displays all fields of TblProduct except CategoryID field and calculate the sub total of product( the products that has unit price greater than 3 dollars). To do so, follow the figure below:

Microsoft Access 2007 calculation field


francis comment


very excellent


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.