Currency Conversion help please

[#1]

I have 2 tables as below

Table1 :

ID Amount

1   450

2   680

Currency :

Curr     FxRt

USD    1.16138809

ADP     3.6729844725

AFN      60.8366792675

I want to convert Amount to diff currency based on the currency table.How can i acheive this ?

Thank you.

[settu_periasamy]

Hi,

Do you want All the amount convert  all the Currency? if so, just join the two table then multiply it.

Like

[engishfaque]

Dear Pavana,

Kindly find attached App.

Kind regards,

Ishfaque Ahmed