2 tables, 1 query, prevent automatic data exclusion

[TheMote]

Hello,



Could someone please help me solve this issue that I am having with a simple query?

Table #1 has a field for storing company names.

Table #2 has fields for storing projects assigned to some of those companies.

My goal is to identify which companies Do Not have a project assigned to to them.

Running a query for CompanyName in table #1 will of course show all companies, but as soon as I add table #2 to the query design mode it automatically excludes all companies that do not have a project assigned to them. What I think is happening is that since Company1 has no project assigned to it, it is therefore not located in the projects table, which means I disappears once I add table #2 to the query.

Thanks

[orange]

Look at the Unmatched query in the Access Query Wizard

[June7]

The query probably has INNER JOIN, change to outer LEFT or RIGHT (I forget which will be correct) - "Include all records from Table1 and only those from Table2 that match".

[TheMote]

The Unmatched query did exactly what I wanted - thank you so much guys!