Show Data in Report and NOT Primary Key #

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

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show actual Text and not Primary Key Number 2
Edit primary key values 3
Changing existing primary key to autonumber 2
Update primary key field with multiple "where" clauses 0
Primary Key 15
Mailmerge displays primary key rather than text 1
Query for Primary key 4
Removing Primary Keys 1

Back
Top