Hello All,
Sorry for another question!!
I have three tables
1. Date range
2. Info
3. Exchange rates
I need to create an update query that does the following:
1. Selects all records in the Info table based on the date range in the date range table - I have done this
2. Then updates all the exchange rates in the Info table based on the exchange rates table....EG
Exchange Rates Tbl
ID Currency Exchange
1 USD 1.00
2 EURO 1.16
3 GBP 1.40
4 EC 2.10
So the query needs to update the records in the info table with the correct exchange rate that corrosponds to exchange rate table....hope that makes sense! The info and currency tables are linked
Sorry for another question!!
I have three tables
1. Date range
2. Info
3. Exchange rates
I need to create an update query that does the following:
1. Selects all records in the Info table based on the date range in the date range table - I have done this
2. Then updates all the exchange rates in the Info table based on the exchange rates table....EG
Exchange Rates Tbl
ID Currency Exchange
1 USD 1.00
2 EURO 1.16
3 GBP 1.40
4 EC 2.10
So the query needs to update the records in the info table with the correct exchange rate that corrosponds to exchange rate table....hope that makes sense! The info and currency tables are linked