dlookup question

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
 
D

Damon Heron

Without seeing the full update query it is hard to see what you are trying
to do. But first off, eliminate the semicolons in the lookup replace with
commas. You know that dlookup returns only one result, right? What is it
you are trying to update?
 
Top