At the current rate, multiply the Canadian amount by .86. $1 Canadian = $.86
American.
But you'll need a way to store the "rate", as that may change over time.
Minor point... please don't type in all caps. It's considered "shouting" in posts.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP http://home.comcast.net/~cccsolutions
"Find a job that you love, and you'll never work a day in your life."
