dlookup question

  • Thread starter Thread starter cyrus the virus
  • Start date Start date
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
 
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?
 
Back
Top