Good morning all!
(I know I'm pretty perky already this morning but I'm on my third cup o' the juice http://www.access-programmers.co.uk/ubb/smile.gif)

I have a question regarding currency conversions:

Is there an activeX control or some other downloadable appendage to deal with currency conversion issues in Access 97'?

If not, I need a little input from you good people...

I would like to set up a check box for the user to be able to select whether or not the customer is paying in a different currency, (if it's different, then the dollar amount would be convereted accordingly). For example...

The standard currency I use is the U.S. dollar. However, due to my state's proximity to Canada, many of our customers will be using different currencies. I want the user to be able to toggle between the two. I already have a daily update form for the user to adjust daily exchange variances, but I'm a little sharky on the code. If someone could help I would appreciate it!

Thanks in advance,
Kevin

You could just write a simple function.
Canadian=US*ConversionConstant
US=Canadian/ConversionConstant

charityg is on target...just an aside, if you are storing the transaction in a table, make certain that you store the converted value, as exchange rates will vary over time. (yes, sometimes one needs to store calculated values!) http://www.access-programmers.co.uk/ubb/smile.gif

al

Thanks Charity and PCS, I really appreciate your help...

Sincerely,
kevin

Hello MSUKevin,

quick question actually on that currency stuff. You might have already filled it.

I have a bounded field containing american dollars. However, I have to be able to change it to Canadian with a click... something like a option button or something. Easiest solution is to have an unbounded box that is calculated using an expression.

HOWEVER, the catch is, if its in Canadian, I have to be able to type in Canadian dollars. The underlying table must be stored in American though. The major problem is you can't even type anything in the unbouded box because its calculated.

So any suggestions?

Thx
Kenta

kwatai,

I'm a little confused on what your trying to do...

Are you saying that if the amount is in Amreican you want to be able to view it in Canadian, and if the amount is in Canadian you want o be able to revert it back to American currency for storage in your table?