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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Get $0.00 to display on a Currency text box on a form 2
Access ACCESS DLOOKUP INVALID USE OF NULL 0
Yet another DLookup problem! 5
Checking if data exists another table and, if yes, extracting a value 0
Multi-Value Combo Box 1
DLookup Expression trouble 5
basics -- using dlookup 3

Back
Top