On Sun, 6 Mar 2005 19:41:02 -0800, KLP
wrote:

At the risk of sounding like a rube, hpw is that done?

Kelvin

"Duane Hookom" wrote:

You should include the "linked to the tables containing the values" in your
queries.

Create a new Query.

Add your main table to the query window.

Add the Lookup Table to the query window.

Select the "lookup field" from the joined lookup table.


Access' Lookup Field is *horrible* for just this reason. It conceals
the actual content of your table. What's stored in the table - and
what gets used in any calculation - is a meaningless ID number. What
you *SEE* on the screen (and reasonably may assume is actually
*there*) is the value from the related lookup table.

You can't get at that looked-up value by simply including your table;
you need to include the lookup table into the query as well (and you
can do so perfectly as well even if no Lookup field exists).

John W. Vinson[MVP]