zakruti.com » IT - Software » Geeks Tutorial

How to Create a Calculation Query in Microsoft Access

video description

Rating: 4.0; Vote: 1

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
Date: 2023-07-08

← How to Open Existing Database in Microsoft Access

How to Create an Update Query in Microsoft Access →

Related videos

The ASUS Dumpster Fire

• Gamers Nexus

Adding Linux GPU Benchmarks: Best Distributions for Gaming Tests, ft. Wendell of Level1 Techs

• Gamers Nexus

After 10yrs of Testing, This is the BEST Upscaler. Period.

• PiXimperfect

HW News - AMD Says AI Definitely, Absolutely Not A Bubble, New Chinese CPUs, RAM Rip-Off Continues

• Gamers Nexus

Nano Banana Officially in Photoshop: 50 EPIC Uses!

• PiXimperfect

JUSTICE: NZXT, Fragile to Pay $3,450,000 for Rental PC Scam

• Gamers Nexus

Comments and reviews: 8

Philip
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!
reply

Pepezilla
Oh WoW, nothing to see here, am just a typical Fury.
ok, Gamers. they are all gone now,
i have infiltrated their base and am going to rescue our allies and will help to save the world
reply

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

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?
reply

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
reply

Information
Thanks man you really saved my life! Best two mins of my day. Can you help me know how to round the value off to 2 decimal points?
reply

Manny
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?
reply

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

Add a review, comment