Convert Currency to another currency amount

[AlaaB]

Good Day Guys,
i have a lite critical issues here and i need you support

1st i have a table contain lots of accounts
i register the amount each time wiht a diffrent type of currency such as (US dollar,euro etc,,,
and the point is that i want to give the final statement and all the currency converted to US Dollar,

2nd i need to make the dollar has a different currency each month, which means that i have to enter the currency of the dollar and the query or the module will covert the whole currency to US Dollar in a new filed


so could any body help me please
waiting your kind reply


Alaa

 

[Steve R.]

Multiple-Post.