How can i use a lookup ?

[old grizzly]

I use a query as the basis for a report. There is a table containing the
data and another table containing choices for drop downs on a form. When I
choose from the drop downs the Text is not stored but the numerical value of
the chosen listed item is stored.
I use a query to select items for the report (which shows the numerical
value) and then also the report shows the numerical value, not the text.

How do I make a setup that will output the text not a numerical value of
the items position in the table?

TIA

Len

 

[Marshall Barton]

I use a query as the basis for a report. There is a table containing the
data and another table containing choices for drop downs on a form. When I
choose from the drop downs the Text is not stored but the numerical value of
the chosen listed item is stored.
I use a query to select items for the report (which shows the numerical
value) and then also the report shows the numerical value, not the text.

How do I make a setup that will output the text not a numerical value of
the items position in the table?

In the report's query, add the lookup table and drag the
related field from one table to the other to establish the
Join connection. Then drag the text field from the lookup
table down to the query's field list and use that in the
report.

 

[old grizzly]

In the report's query, add the lookup table and drag the
related field from one table to the other to establish the
Join connection. Then drag the text field from the lookup
table down to the query's field list and use that in the
report.

Many thanks, just the job!

Len