DLookup in Queries

[Garry]

I'm trying to use Dlookup in a query and just can't seem to get it setup right. The Query is based on table: Coin Collection Table.

I'm trying to pull Exchange Rate from a table 'Coin Country Table' into my query. This is what I've got

Exchange Rate: DLookUp("[Exchange Rate]","[Coin Countries Table]","Country=" & [COUNTRY])

[June7]

What is wrong, what happens - error message, wrong results, nothing?

Is Country a text field? If so, need text delimiters.

Exchange Rate: DLookUp("[Exchange Rate]","[Coin Countries Table]","Country='" & [COUNTRY] & "'")

Can't you just do a query that joins the tables on country fields?

[Garry]

I get an error message: #Error
country is a text field in the query and the Coin County Table
I can do such a query, but the result isn't updateable, and I need to be able to update it.

[June7]

Why isn't join query updatable? Post the query. Which table do you want to edit?

The DLookup syntax is correct but apparently Access can't find field or table. Make sure everything is spelled correctly.

[GinaWhipp]

I'm trying to use Dlookup in a query and just can't seem to get it setup right. The Query is based on table: Coin Collection Table.

I'm trying to pull Exchange Rate from a table 'Coin Country Table' into my query. This is what I've got

Exchange Rate: DLookUp("[Exchange Rate]","[Coin Countries Table]","Country=" & [COUNTRY])

Hmm, is the table named *Coin Country Table* or Coin Countries Table*? Another thought, seems to me those two table should be related (if they are aren't seems like they should be) via *CoinID*, so why not just drop the table in the query window and then put your field in?

[Garry]

Couple of you were on the right track about relating tables/queries. I just thought it was normal a query with related tables wouldn't be updateable.
So I read up on queries and checked out my relationships - and found an error.
Now I've got everything working.

Thanks all.