Conditional criteria in query
I have a query in which I try to calculate field values depending on the currency and foreign exchange rates.
I have a currency field with the amount value and a combo box where I select the currency for that amount which can be (USD, Euro, BRL, or INR). I have got also another 4 fields with each of currency foreign exchange rates.
I am trying to obtain a new calculated field of Price in Euros if the amount I have in the 1st field is not already in Euros.
Field 2---------currency (can be in USD or Euro or BRL or INR
depending on a refNo)
Field 3-------------xchange rate
Field of Results-------------field1 * field 3 in Euro depending
on the currency in field 2.
My understanding is that it can only be done using vba and I am not very familiar with vba. Can anyone help, please?