Hi,
Apologies, it's been a while since I've done anything in Access and my brain has turned to mush! I'm sure this is very simple....
I have a table with some amounts with differing local currencies. I have another table with the currencies and the GBP equivalents.
I need to run a query to convert the local currencies in table A to the GBP equivalents in table B.
Seems very straightforward but I just can't seem to achieve it. The queries I'm writing that do achieve it are sooooooo slow so there must be a better way?
Thanks,
Adrian
Apologies, it's been a while since I've done anything in Access and my brain has turned to mush! I'm sure this is very simple....
I have a table with some amounts with differing local currencies. I have another table with the currencies and the GBP equivalents.
I need to run a query to convert the local currencies in table A to the GBP equivalents in table B.
Seems very straightforward but I just can't seem to achieve it. The queries I'm writing that do achieve it are sooooooo slow so there must be a better way?
Thanks,
Adrian