Lookup Fields in a Report

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

Guest

I have created a report that has a lookup field in it.

The report is displaying the primary key number instead of the text of the
lookup field. How can I get it to display the text?
 
Avoid lookup fields. Include the table that stores the "text" in your
report's record source so that you can display the "text".
 
U¿ytkownik "Pitchcrimson said:
I have created a report that has a lookup field in it.

The report is displaying the primary key number instead of the text of the
lookup field. How can I get it to display the text?
Click to expand...
 
U¿ytkownik "Pitchcrimson said:
I have created a report that has a lookup field in it.

The report is displaying the primary key number instead of the text of the
lookup field. How can I get it to display the text?
Click to expand...
 

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

Need help with combo box lookup reference in a report 6
Report field prints white on black 1
Report Shows ID instead of Text 4
Report based on Query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Return Desired Value in a Text Box 4
Display Text vs bound column 2
color in field of a report??? 4

Back
Top