Hello!!
So I've two tables:
1. tblExpenses
2. tblCurrency
tblExpenses has a currency field which it looks up the value from tblCurrency, it also has an exchange rate field
tblCurrency also has an exchange rate field where I can set the exchange rates for each currency
I need a query to update the tblExpenses Exchange rates with the corrosponding exchange rate for the correct currency from tblCurrency, so it would look like:
tblExpenses
Date Currency Exchange Rate
1/1/21 EURO
2/1/21 USD
2/2/21 EC
3/2/21 EURO
tblCurrency
Currency Exchange Rate
EURO 1.15
USD 1.00
EC 2.70
How can I make an update query that finds the correct value from tblCurrency!Exchange and updates it into tblExpenses!Exchange Rate, would it have to be a lookup criteria in the update query?
Thank for your help.....banging my head on computer now!
So I've two tables:
1. tblExpenses
2. tblCurrency
tblExpenses has a currency field which it looks up the value from tblCurrency, it also has an exchange rate field
tblCurrency also has an exchange rate field where I can set the exchange rates for each currency
I need a query to update the tblExpenses Exchange rates with the corrosponding exchange rate for the correct currency from tblCurrency, so it would look like:
tblExpenses
Date Currency Exchange Rate
1/1/21 EURO
2/1/21 USD
2/2/21 EC
3/2/21 EURO
tblCurrency
Currency Exchange Rate
EURO 1.15
USD 1.00
EC 2.70
How can I make an update query that finds the correct value from tblCurrency!Exchange and updates it into tblExpenses!Exchange Rate, would it have to be a lookup criteria in the update query?
Thank for your help.....banging my head on computer now!