How to Switch from USD to EUR, CAD, AUD, etc.

In this video, I will show you how to convert currency from one type to another. We will learn how to convert US to Canadian dollars, but the same technique applies to Euros, Australian Dollars, etc.

Rodney from Buffalo, New York (a Gold Member) asks: We are located near the Canadian border. We do a lot of business in Canada. Is there an easy way to display our prices in both USD and CAD without having to manually change them all the time, everywhere in the database? It would be nice to just go into a form in the database once a day and type in the current conversion rate.

Members

Members will learn how to create a currency conversion table so you can easily switch between multiple types of currency, and display more than one currency on your forms, reports, etc.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!

Links

• DLookup Function: https://599cd.com/DLookup
• Calculated Query Fields: https://599cd.com/Calculated
• Round Function: https://599cd.com/Round
• Banker's Rounding: https://599cd.com/ACX8

Auto Update Rates!

If you want to learn how to automatically update your currency conversion rates, I cover that in Access Developer 32. 

Currency Symbols

If you want to use the actual currency symbols like $ € ¥ £ ¢ ﷼ ₽ etc. see this video: Currency Symbols

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, how do you change currency to dollars in access, microsoft access convery currency, round function, ccur function, convert to currency, bankers rounding, round, int, fix, dlookup, Currency Converter Template, Microsoft Access Currency Converter Database, convert values from one currency to another, calculate exchange rates