Query using two tables does not return values for certain parame Version: 2002

[shapman]

Hi

I have a query that runs off three tables: These are tbl_contacts, tbl_status, tbl_publications. All contacts have a status but not all will have a publication. The problem is that when i run the query on a status type where none of the contacts for that status have a publication it will return no results, where what I actually need is for it to just return the details of those contacts for that status. The whole query runs off a form with combo boxes.

grateful for any advice
Shapman

 

[neileg]

You need to change the joins between the tables in your query. Access defaults to an inner join which only returns results when there are matches in both sides of the join. If you change the join to an outer join it will return all the records from one side and any that match from the other. Right click on the join line in the query grid and select a type 2 or 3 join whichever is appropriate.