Returning all fields

M

me

I have a query that is based on 5 tables. Each table has data about skills
employees have performed. However each table does not have information on
all of the employees. My problem is that the query only returns records for
employees that have data in all the tables. Anyone have any idea how I can
correct that. Thank you
 
R

Rick B

Check your joins. You probably have them set to pull records where the
value is equal in both tables.

You need to pick a table that has all the employees (maybe an employee
table) and then join the five related tables you mention. Set the join to
pull all records from the main table and only those records in the other
tables where the values are equal.
 
Top