Let me preface my query by saying I am an MS ACCESS Novice. I see that most people provide just sql code for answers on here. I need to understand my solution conceptually first so I would appreciate a very laymen's explanation.
I have a database which tracks costs across several countries. These costs are inputted by the users in local currency, so British Pounds, Polish Zloty, Danish Krone, etc...
I need to convert these costs into Euros. I am aware the solution involves creating a table with the Euro/Local exchange rates and querying the data entry table with the exchange rate table to get the conversion. I have my table with exchange rates but cannot get further than that.
All help is very much appreciated.