Retrieve Specific Contacts (1 Viewer)

[ccflyer]

Hey Everybody,

I have 2 tables, one called [Addresses] and the other called [2006_Contacts]. The table [Addresses] has a number of various fields relating to contact data of people. The [2006_Contact] table has 2 fields [Last Name] and [First Name]. I want to run a query that pulls the contact data from the main [Addresses] table, but only if the contact name ([First Name] and [Last Name]) are present in the table [2006_Contacts].

Does anyone have any suggestions?

Thanks,
Chris C.

 

[neileg]

If you join the two tables in a query using an inner join (type 1 in Access terms), you will only return data if there is a record in both tables. I think that will give you what you want.

 

[ccflyer]

Hey neileg,

That sounds like it would probably work. I know how to the two tables together, but how do you return a record only if it is present in both?

 

[neileg]

That's what I explained! Create a query, bring in both tables, join them with an inner join. That's the default join in Access, so you really don't have to do any more.

 

[ccflyer]

Ok, I see what you are saying now.

Thanks,
Chris