In a Report, how do I display the text not the ID value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to generate a report from table#1 that looks up organization
names from table#2. When I include the organization field from table#1 in my
report, the report displays the numerical value stored in table #1 not the
actual text of the organization name stored in table#2. How do I get the
report to display the text value from table #2? I'm just getting started
with access and tried finding this in a book I have and on the help topics
but to no avail. Any help would be greatly appreciated. Thanks.
 
Sounds like you've used that misguided misfeature known as the Lookup Field
(see http://www.mvps.org/access/lookupfields.htm at "The Access Web" for
some of the reasons why many of us feel this way)

You're going to have to create a query that joins together the two tables in
order to include the text from table#2, and then use that query as the
RecordSource for your report, rather than simply using table#1.
 
Rob said:
I am trying to generate a report from table#1 that looks up
organization names from table#2. When I include the organization
field from table#1 in my report, the report displays the numerical
value stored in table #1 not the actual text of the organization name
stored in table#2. How do I get the report to display the text value
from table #2? I'm just getting started with access and tried
finding this in a book I have and on the help topics but to no avail.
Any help would be greatly appreciated. Thanks.
Click to expand...

You need to mak sure you have a proper relationship set up between the
two tables and I suggest setting up a query including both related tables
and use that as your record source.
 
For the report's RecordSource use a query which joins the two tables on the
numerical ID number fields, and which includes the organization name from
table#2 as a column in the query's output. You can then bind a control in
the report to the organization name column rather than the ID number.

Ken Sheridan
Stafford, England
 
Back
Top