By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,257 Members | 2,812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,257 IT Pros & Developers. It's quick & easy.

Can't get second table data to show in report

100+
P: 114
I have a Report that uses a master table and has been working ok. Now I need to add some data from a second table called locations.

The master table has a column named loc_code, and the locations table has a primary key named loc_code. I checked and the relationship of the two tables and it looks to be fine.

Now I need to show the loc-name, loc_addr, etc from the locations table on this report. Not sure how this is done with Report in Access. How do I use the loc_id in the master table to match to loc_id in the locations table and use column data on this Report.

When creating the text box on the report, do I use the expression builder in the control source of the properties for each column that I want to place on the report or is there another way to accomplish this.

Thanks for any help and are there any examples someone could point me to.
Mar 10 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,494
You need to create a query where the two tables are linked and use that query as the source of your report.
If you need precise help with this you will need to post the MetaData for your tables - at least the relevant parts.
EG.
Table Name=Master
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; AutoNumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Mar 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.