I have two tables and In one table I have currency field and transaction amount. Other table has Currency and the conversion Rate. There I want to get the monthly average rate and convert all amount to LKR currency. Currently five currencies avalable,(LKR, USD, EUR, GBP, AUD). But it is better to give a way to convert any currency. Please help on this.