Access Query/ Form question

[Guest]

I have 3 tables

Table 1
employee #1 John Smith
employee #2 Joe Smith
employee #3 Sally Smith
etc.

Table 2
employee #1 500
employee #3 400
employee #5 600

Table 3
employee #1 300
employee #4 250
employee #6 50

I want to do a query or form that shows the following results:

employee #1 John Smith 500 300
employee #2 Joe Smith 0 0
employee #3 Sally Smith 400 0

The way that I am doing it, it pulls only those employees that have an entry
in each table (like employee #1)

What am I missing?

Thanks in advance.

 

[Guest]

Take a look at left outer joins in the help file, that should help your problem

 

[John Vinson]

The way that I am doing it, it pulls only those employees that have an entry
in each table (like employee #1)

What am I missing?

The optional Join type.

By default, joining two tables uses an "Inner Join" - select only
those records with data in both tables.

In the query grid, select the join line and view its properties.
Change the join type from option 1 to Option 2 (or maybe 3) - "Show
all records in Empllyees and matching records in <other table>".

John W. Vinson[MVP]