totn Access

MS Access 2003: Create a query using a Left Join

This MSAccess tutorial explains how to create a query using a LEFT JOIN in Access 2003 (with screenshots and step-by-step instructions).

Question: In Microsoft Access 2003/XP/2000/97, I want to join 2 tables together. But I need to retrieve information even if there is no related information in the second table. How can I do this?

Answer: To retrieve your data, you will need to perform a left or right join. In this example, we'll demonstrate how to accomplish this query using a left join.

First, create a new query and add the 2 tables to the query.

Microsoft Access

Right click on the "join line" between the two tables and and select "Properties" from the popup menu.

Microsoft Access

When the Join Properties window appears, select the second option and click on the OK button.

Microsoft Access

Your query should now look like this. You will notice an arrow on the right-side of the join line. (between the JobDeptDesc and ArchiveData tables)

Microsoft Access