How do you get a lookup field to show as text in a report?

[Guest]

My query pulls data from a table with a look-up field and the numeric ID is
what shows up in my report. How can I get the text that is linked to the
number to show up instead?

 

[Yumex85]

You can make a inner join with the table that has the text.
select textfield from table1 inner join table2_withtext where
table1.numericid = table2_withtext.numericid

 

[Guest]

The first thing you should consider doing is an exocism of all table lookups
in your database. Lookup fields defined at the table level are the creation
of the evil one. See the 2nd commandment here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm

Then, to get the looked-up value to display, add the lookup table to the
query, and add the appropriate field from this table. Note: You may need to
use an Outer Join, instead of the normal default Inner Join, especially if
your foreign key fields can be null.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Can you tell me exactly how to do that? My look-up table is Vendor with
Vendor ID and Vendor Name as fields, and the data table is POR with Vendor as
the look-up field.