Generate Reports from Multiple Tables

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

Guest

How can I generate a report pulling variable fields from multiple tables?
Currently, I have a main table, Employee_Profile that is linked by an
Employee_Key field to other tables. When a query is built from two tables
the query returns blank results. We do have data input in all forms. Is
this a relationship issue within the tables?

Thanks.
 
Nash

How does your query link the two tables? Post the SQL statement of your
query.

Are you absolutely certain that every record in your table1 has a
corresponding record in table2? If not, you may need to modify the
properties of the join to reflect the fact that you need all from table1 and
any from table2.

When you say "linked", do you mean that the value in your main table's
Employee_Key field is also in a foreign key field in your "other" tables?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Generate a Report from Multiple Tables 1
Reports that sift records from different tables 0
Report Sum with Multiple Relationships 2
Can't create a report from my query in Access 1
Access Dcount (multiple criteria) 3
Single Report from teveral tables with a single to many relationsh 1
Multiple Reports – Same Query – Underlying Data Changes Frequently 3
Multiple Reports – Same Query – Underlying Data Changes Frequently 1

Back
Top