thankQ Help

Another table can be joined to the table selected if the fields required are not in the current view.

When you require another table they need to be joined by either an Inner join or an Outer join to fields that exist in both tables.

An Inner join is where the information is required in both tables and an Outer join is where the information can be in one table but not in the other. E.g. You want a list of all contacts that have donated as well as contacts who have not donated. You would use a Contact table for all the contacts and a Donations table for those who had donated. If you join these with an Outer join you will get all contacts from the Contacts table and the contacts who donated from the Donation table.

1.Locate the table View_Donations and double click to move it to the list

2.Click on <Select a column>

3.Select the field to join the tables together

4.Click on <Select a table>

5.Click on the table

6.Click on <Select a column>

7.Select the field

8.Click OK

This will add the table to the Query showing the join