How to Create a Calculation Query in Microsoft Access

In this tutorial, we will teach you how to create a calculation query in Microsoft access.

Create a calculation query in Microsoft Access and enter data so as to find out the calculate results of your entries in the table.
It is possible to perform calculations within your queries. Over here, we will make a Query that will give us the total price on each order. To learn how to create a query in Access, follow the steps given below.

Step 1 -- Go to the "create" tab

To create a calculation query in Microsoft Access, let's go to the "create" tab and click on the "query design" button. Over here, we will select the products, orders, salesrep and customers tables and close the show table window.

Step 2 -- Select data from the tables

Now let's select the order date from the orders table, company from customers table, product, size and price from the products table, quantity from the orders table and lastly the last name from the sales rep table.

Step 3 -- Update the query

Now let's move to the last column then click on the builder button, located in the ribbon on top. Over here, write "total" followed by a colon. This lets access know that this is the field's caption. Now click on the plus sign and next to the file name, in the expression element area. Over here, let's expand the tables and then double click on the products table.

With that done, let's click on price over here and notice that in the query has been updated. Now let's add an asterisk sign in the query for multiplication, then go down to the orders table and double click on quantity.

Now let's click on the OK button to proceed and click on the view button to check the output of the query in Microsoft Access.

Step 4 -- View the list

And there you have it. Over here, you can see the details such as the order date, the name of the company who ordered, the size for the product, quantity of the product, name of the sales person and the total price for their order, which is being tabulated through the query we just entered.

By following these steps you can learn how to create a query in Access.

[howtechoffice]

❗ Subscribe To Our Main YouTube Channel

[lzlenzo]

Thank you so much!this 1.5 min tutorial video helped me out :)

[looestar]

Thank You. I have soent all day trying to do this, then I found your video tutorial. It was spot on and more importantly came straight to the point - THANK YOU

[dferver]

I spent way too long on a project for school and after watching this vid 2x I got the calculation to work! Thank you. Also I agree with Will Thompson - Why DID you delete the 'expr', and not state that you did this or why you did this? Thank you for explaining how to Total from multiple fields!

[RRedits]

Thank u so much u helped finish my sba early 🎉 Ik I’ll pass my CXC exam thanks to u

[ccpd]

tu video me ayudo mucho, te lo agradezco.

[fredmakori]

Thankyou so so much, I really appreciate this

[MannyNieves]

Thanks for the video. How about if I have several sales for the same customer but I want the final total amount for each customer?

[TheProfessinal]

Difference between 10 and 15 points. Thank you!

[tajmatharu]

could you please tell me where are the sample files? ie the one above and others on your website please?

[ebsmith]

So how do you put addition with actual numbers into it ?

[cynthiacooper]

see how there are two mitchells how do we get those totals to combine as one total...

[enrish]

How do you calculate multiple products with multiple quantities in one order? I want to create a report that shows the total per product(price*qty) and the total for the overall order

[SkillzHD]

How do you make the total to be formatted into a data type of currency?

[QuantumNaut]

When i click Run nothing appears HELP!

[willthompson]

Why did you delete the 'expr' thing right before running, and why didn't you explain that step?

[rabiul]

August > September returns true as well as November > September returns true too, that is not fair. Actually I was trying to compare between two months, is it possible in Access?

[iambored]

You really ought to add an annotation or something that says to delete the "expr" part.

[marciabrar]

Can anyone mention here what did me mention in the last calm ???

[abeedahfarjan]

watching this because im doing practical based on access