How can i use a lookup ?

  • Thread starter Thread starter old grizzly
  • Start date Start date
O

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
 
old said:
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?
Click to expand...


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.
 
Marshall Barton said:
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.
Click to expand...


Many thanks, just the job!

Len
 
Back
Top