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
 
Back
Top