Value of a Look Up Field

[Guest]

Good Day,

I am creating a report that has a field that is based on a look up
field: so therefore, when I create my report, it shows the field with as a
drop down box. But here is my delima.

I want to create a "concatinated" text box that has several values
together, but when I created this concatinated text box, it only shows the
"column number " of the "lookup" column.

How do I set my text box to show the actual value of the feild and not the
column number of my look up box.

Thanks,

Brook

 

[Duane Hookom]

Consider reading about the ills of Lookup Fields at
http://www.mvps.org/access/lookupfields.htm.

You must include the table that is the Row Source of the lookup field. You
can then use the "looked up" value in your report.