From the course: Access 2019: Queries

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Convert US dollars to Canadian dollars

Solution: Convert US dollars to Canadian dollars

From the course: Access 2019: Queries

Start my 1-month free trial

Solution: Convert US dollars to Canadian dollars

“

(ethereal music) - [Instructor] So were you able to provide a query that provided our product listing about US dollars and Canadian dollars? Here's how I go about solving this problem. First, let's do a quick little bit of web research. Open up my web browser here. And I'll do a search of one USD in CAD, CAD standing for Canadian dollars. I can see that the current exchange rate is 1.3 Canadian dollars to the US dollar. So that piece of information in mind, we'll go ahead and close this tab, go back and create a new query in Design view. We're going to pull in the Products table and then I'm going to add all the fields from the Products table to my query design grid. Then, in the field right after the last price, I'm going to right click, and go into the Expression Builder. Then I'll drill into the Database folder, expand Tables, expand the Products table, double-click on Price and I'll simply multiply that by 1.3. Then I'm going to give this a proper alias here at the very beginning,…

Contents