Pulling two tables together & keeping all records, not just matchi

I have two tables that I would like to pull together. One is called
organizations and one is CEO Contact. If I create a query with the fields I
want, it only creates records where all of the information exists. What also
need to have is the organization record even if the CEO name is not in the
CEO table. I would greatlly appreciate a point in the right direction.

In query design view, double click on the line between the two tables until a
dialog box shows up. The default option 1 is an inner join where both tables
need a matching record.

Option 2 is a left join and option 3 is a right join. They will return
records even when one table doesn't have a matching. Try option 2 and if that
doesn't work option 3.

There is no option 4 which is a full outer join. If both tables are missing
records that match those in others, Access can handle it with a simple join.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"trypsin25" wrote:

I have two tables that I would like to pull together. One is called
organizations and one is CEO Contact. If I create a query with the fields I
want, it only creates records where all of the information exists. What also
need to have is the organization record even if the CEO name is not in the
CEO table. I would greatlly appreciate a point in the right direction.

Typo. It should read:

Access can't handle it with a simple join
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Jerry Whittle" wrote:

In query design view, double click on the line between the two tables until a
dialog box shows up. The default option 1 is an inner join where both tables
need a matching record.

Option 2 is a left join and option 3 is a right join. They will return
records even when one table doesn't have a matching. Try option 2 and if that
doesn't work option 3.

There is no option 4 which is a full outer join. If both tables are missing
records that match those in others, Access can handle it with a simple join.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"trypsin25" wrote:

I have two tables that I would like to pull together. One is called
organizations and one is CEO Contact. If I create a query with the fields I
want, it only creates records where all of the information exists. What also
need to have is the organization record even if the CEO name is not in the
CEO table. I would greatlly appreciate a point in the right direction.