Query not returning ALL Amployees?

[galvinjaf]

Good Morning,

I created a query that will give me a list of information from a few different tables based on an employee.

I've run the query, but it doesn't return ALL of my employees. The data it does return based on employees I do see, is accurate.

Any ideas? I've attached a screen shot.

Thanks.

 

[plog]

An INNER JOIN is effectively criteria. For a record in tblEmployee to appear in the results, it must have matching data in all those linked tables.

You can override this by making your joins LEFT JOINS. You do that by right clicking on the linking lines between tables, clicking on 'Join Properties' and changing the box that comes up to the one that says something like 'Show all from ' and then the table on the left side of the connection.

That's the issue, whether or not its what you actually want is up to you.

 

[galvinjaf]

I learn something new every post. Literally.

Worked like a charm, and makes sense. Thank you. Very much appreciated.