filter one table with another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello - I have 2 tables both created by MakeTable Query. Both were designed
for mailing labels. We have sent invitations to the people in the first
table and would like to send invitations to the people in the 2nd table, but
some of those people are also in the first table. How can I sort out the
people we have already sent invitations to so that they don't end up with
duplicates.

Thanks.
 
Open to the database window - Queries. Click New. Select Find Unmatched
Query Wizard and follow the directions. The wizard will create a query that
returns the people in the second table who are not in the first table.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Or as an alternative to steve's answer you could use a union query which also
eliminates duplicates.

Select [field], [field], etc... From Table1
Union
Select [field], [field], etc... From Table2

For the union query the fields should be equal to fieldnumbers so if table
one has three fields table two should also have three fields.

hth
 
Back
Top