Display Data in A Report

C

Chris A

I am trying to create an Access report from a table which is linked to
other tables via different keys. In the main table where I am trying to
create a report from, I want the report to display more fields that
just the key. For example, instead of showing a member's ID # since
this is the key I linked to the table, I want the report to show the
member's first name and last name as well. How can this be done?
Please advise.
 
R

Rick B

Just include the linked tables in your record source and pull the
appropriate fields from them. You can include multiple tables in the
report's underlying query.

Note: You posted to a forms group, but you say "report". I have answered
this question as though you are creating a report.

Rick B
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
Auto populate value from one task to another in MS PROJECT 0
Linking data in MS Word into Excel 5
VBA word change keys 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Cannot see and gantt charts or other displays 0
Possible to Combine reports to's to a single box? 0

Top