Query to contain null values (1 Viewer)

[bday]

Currently I have a querry pulling employee data from several tables (experience, education, awards, etc...). My problem is that if a record (employee) is on the experience and eduation tables but has no awards and is not on the awards table, then they will not be displayed in the query. I would like all employees displayed in the query even if they are not on all tables. How can I set up my query to do this? I am using 2007.

 

[khawar]

Check the attached file
Employee A has reward and employee B doesn't have any but query shows both employees

 

[bday]

The relationships and joints are similar to what I had. I tried several different adjustments to no avail. I still onyl get 2 people in the guery that have data entered in all tables.

 

[bday]

Scratch that last post. I got it to work. I now see all records in the query that are in the employee table even if an employee is not in the awards table.

Thanks!!