Calculating Exchange rates

[Simon M]

Hi all

I have a table with two columns showing currency and
exchange rates. However, in another table I would like to
be able to recognise the exchange rate entered and then
this to work out the USD amount from the above mentioned
exchange rates. I guess this wil be a "query" issue.

Any help would be great!

Cheers,

Simon

 

[hcj]

Hi Simon,
I think you're right - I'd look at an Update query which
joins the two tables (TblA is the data table, TblB is the
Exchange Rate table) throught the currency type. Update
the USD field in the working table (TblA) with =TblA!
amttoconvert*TblB!exchangerate (or possibly /TblB!
exchangerate, depending on how you've entered the rate)

It would be nicer if the USD amount would fill in
automatically when a new record is created in TblA, but I
don't know how to do that. Maybe someone else can help
there.

If you go with the update query idea, you'll have to
remember to run the query from time to time, or run it
whenever you close TblA.

Hope this helps.

 

[John Vinson]

Hi all

I have a table with two columns showing currency and
exchange rates. However, in another table I would like to
be able to recognise the exchange rate entered and then
this to work out the USD amount from the above mentioned
exchange rates. I guess this wil be a "query" issue.

Please post an explanation of the structure of your tables and how
they are related.