Input Box Question

  • Thread starter Thread starter Steve Davey
  • Start date Start date
S

Steve Davey

Hi, I'm trying to build something where a user inputs a currecy code and
amount, and another currency code, and the database calculates the other
currency amount applying FX rates from a table.
Is this possible?
 
Ah...sorry Bruce.

A currency code would be something like "GBP" then I'd enter "1,000,000"
then I'd enter "USD".
I'd have a list of "FX Rates" in a table, where I'd look up GBP/USD and it
would give me 1.55 lets say, then using that rate I'd multiply it against the
1,000,000.

I'd then like to create a record that I can use stating GBP 1,000,000 USD
1,550,000
Hope I've explained myself....
 
On Thu, 11 Feb 2010 06:18:02 -0800, Steve Davey <Steve
Hi, I'm trying to build something where a user inputs a currecy code and
amount, and another currency code, and the database calculates the other
currency amount applying FX rates from a table.
Is this possible?
Click to expand...

As Bruce says, we need more info to be helpful; but the Access tool would be a
Form with textboxes for the two currency codes. You'ld need some sort of query
to look up the exchange rate, but the details would of course depend on your
table structure (which we do not know).
 
Back
Top