I have a need if possible for an access query to convert currencies.
The data is a follows (this is simplified)
Column: Ref Currency amount1 amount2 amount3
Data :a123 Eur 100 125 85
b765 GBP 250 75 0
A324 sek 500 500 15000
I would like to convert all this amounts to GBP. So Im guessing that I need to somehow check the currency field, then apply a formula that converts those amounts to GBP. I was thinking that adding a table called convrates, that list all the possible currencies in the DB along with the conversation rate and then somehow link this and convert the amounts