Linking Fields

[Cori]

Good morning everyone

I was wondering if there is a way to link one field from a table to another table?

I have a main table that all of the data goes to and then a second table that the completed data goes to. I have made a query to show info from the main table and one field from the second table and it will only pull the info that is on both tables...i want it to tell me the info that is not on the second table

Sorry if this is confusing, but any help would be appreciated...thank you
Cori

 

[pbaldy]

The simplest way to find records not in the second table is the unmatched query wizard.

 

[Cori]

What exactly is the unmached query wizard? I have used the query wizard under the query tab on the objects window, but that gives me the information that i don't want...is there a criteria that i should be typing in to get everything that is not on both tables?

 

[boblarson]

When you start a new query you get a dialog that allows you to select the type of query you are going to want and one of them is
"Find Unmatched Query Wizard"
and then you just select that one and it will ask you for the tables, or queries, you want to check and the key field that would be the same in both.

 

[Cori]

Thanks...i think that worked

 

[neileg]

Mmm...

I think what you want is a different join between the tables. The default join in a query in Access is an inner join. This returns data only when matching records exist in both tables. If you change the join (by right clicking the join line in the query window) you can change the join to show all the data from one side and anything that matches from the other. This is known as a left or right join, depending on which way round the tables are.