Show Data in Report and NOT Primary Key #

T

TKM

How do I get the actual text that is associated with the number (primary key)
I recived from my CBO in my table? I need to show the actual text and not the
number in my report. I know this can be done in a query but I cannot get it
to work. Trying for 1 hour now and its time to ask the pros.

Thanks again
 
A

Amy Blankenship

TKM said:
How do I get the actual text that is associated with the number (primary
key)
I recived from my CBO in my table? I need to show the actual text and not
the
number in my report. I know this can be done in a query but I cannot get
it
to work. Trying for 1 hour now and its time to ask the pros.
Click to expand...

In the query designer, show both the table that contains the number and the
table that contains the text the number is associated with. If there is no
join line between them, drag the numeric field from the second table to that
same field on the first table. Double-click the names of the fields in both
tables that you'd like to use in your report.

HTH;

Amy
 
Top