C
cyrus the virus
Can anyone help me with the DLOOKUP function in Access ?
Basically, I have a table FX_TABLE with two columns named CURRENCY and
FX_RATE and another table VALUE_TABLE with values in different
currencies in the VALUES column.
I created un update query using DLOOKUP to find the appropriate FX_RATE
and multiply it with the VALUE, something like this :
=DLookUp("[CURRENCY]";"FX_TABLE";"[FX_RATE]") * [VALUE_TABLE]![VALUES]
??
Thank you in advance
John
Basically, I have a table FX_TABLE with two columns named CURRENCY and
FX_RATE and another table VALUE_TABLE with values in different
currencies in the VALUES column.
I created un update query using DLOOKUP to find the appropriate FX_RATE
and multiply it with the VALUE, something like this :
=DLookUp("[CURRENCY]";"FX_TABLE";"[FX_RATE]") * [VALUE_TABLE]![VALUES]
??
Thank you in advance
John