Building calculation queries


show more Building calculation queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Building calculation queries

It's possible to run calculations within your queries. Let's make a query that gives us the total price on each order. Create a new query by clicking on the Create tab and then on the Query Design button, add the Products table, the Orders table, the SalesReps table, and the Customers table, and then click Close. Now double-click on the OrderDate and instead of choosing the company from here, that would give us just their ID code, we want their whole name, so let's pick it from the Company field in the Customers table.

Same thing for the Product. I could pick the product from here, but again it would give me the code. So let's pick the product name from the Products table. Now let's pick the Size and the Price, which will give us the details about what they ordered, and then from the Orders table, pull in the Quantity. Now I like to know which sales rep helps them and since the SalesReps is associated with the Customers, I could pull the SalesRep from here, but instea...

Building calculation queries
Video duration: 2m 44s 3h 30m Beginner

Viewers:

Building calculation queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...