From the course: Access 2016: 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 2016: Queries

Start my 1-month free trial

Solution: Convert US dollars to Canadian dollars

“

- [Voiceover] So were you able to create a query that provided our product listing in both US dollars and Canadian dollars? Here's how I go about solving the problem. First step is to figure out what the current exchange rate is. So I'll just go ahead and switch over to Google real quick. And we'll do a search here for one USD in Canadian dollars. And we can see that the current exchange rate is one dollar is equal to $1.28 in Canadian dollars. Let's go ahead and go back in to Access and we'll start creating our query in design view. So we're gonna take our products table here, and I'll add that in. Now I wanna add in a few fields. I'm gonna add in the item name, the size, the color, and the price. In the next field I'm gonna right click and go into my expression builder here. Or I can go ahead and start building out the function that is going to multiply our current price times the exchange rate. Go ahead and find the products table. Double click on price to add that up here, and…

Contents