Need Help to Display all Records for a query

[robkiolbasa]

Hello, I am pretty new to Access and would like to know if there is a
quick solution to the following.

I am running a query against 2 tables, change and employee. The fields
I am interested in are change.summary, change.description and
employee.name. For some records in the change table, these is no
employee associated with them. I would like those records to display in
my query, but when I run it only the records that have an employee
assigned to them are displayed. Is there a way to set my query so that
all records are displayed?

Any help is appreciated, thanks in advance.

 

[NathanJ]

You need to use an outer join to show the records without changes
associated with them. The easiest way to do this is to double click the
join line between the two tables and check the radio button that
corresponds to include all records from change table.

Hope this helps

-Nathan

 

[robkiolbasa]

Thanks Nathan, worked out perfectly.

You need to use an outer join to show the records without changes
associated with them. The easiest way to do this is to double click the
join line between the two tables and check the radio button that
corresponds to include all records from change table.

Hope this helps

-Nathan