In a lookup column, looking up multiple fields, can I change whic.



In a table of "internal training", I have a lookup column which looks up an
employee key, employee last name, and employee first name. When I try to
include this in a report, only the employee key is displayed. Is there a way
to display the first and last names instead?




Hi, Thunder.

Sure. Create a query that includes your Internal Training and Employee
tables. If you've created a relationship or used the same field names,
Access will display a relationship between the Employee Key and its foreign
key counterpart in Internal Training. If not, establish the link by dragging
one to the other.

Select the fields from each table that you wish to use in your report,
including the first and last names and save your query.

The query now behaves just like a table--base your report on the query and
you can place the names, or a calculated field such as:

= [LastName] & ", " & [FirstName]

Hope that helps.

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

multiple column lookup 1
wrong field shown in look up column 2
Look up field on form 1
deleting lookup fields from a database field (column) 1
Lookup fields 3
lookup field 2
Lookup field 4
Lookup fields 1