Show actual Text and not Primary Key Number

[Guest]

Most of my tables now carry the Primary Key number in certain tables for
selected data in CBO. I need to extract the actual text that is associated
with the number listed in my table and show it on my reports. I know it can
be done in a query but don’t know how. Can someone help me out on this one?

Thanks again

 

[Marshall Barton]

Most of my tables now carry the Primary Key number in certain tables for
selected data in CBO. I need to extract the actual text that is associated
with the number listed in my table and show it on my reports. I know it can
be done in a query but don’t know how. Can someone help me out on this one?

Without moew specific information, try using something like:

=DLookup("textfield", "thetable", "keyfield=" & keytextbox)

 

[John W. Vinson]

Most of my tables now carry the Primary Key number in certain tables for
selected data in CBO. I need to extract the actual text that is associated
with the number listed in my table and show it on my reports. I know it can
be done in a query but don’t know how. Can someone help me out on this one?

Thanks again

Create a Query by adding your main table to the query design window, and then
adding all of the needed lookup tables. Access should join the lookup tables
by their primary key - if not, join them. Select the looked-up value from the
joined lookup table.

Base your Report on this query rather than directly on the table.

John W. Vinson [MVP]