Not It Query

P

PeterM

I have two tables. TableA contains contact names. TableB can contains a
subset of the contact names in TableA.

I need to create a query where I can populate a listbox with all TableA
contact names not in TableB.

any help would be appreciated

thanks in advance
 
D

Duane Hookom

There is a "Find unmatched query wizard" that does this. Create a new query
and step through the wizard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete Using Join Statement 4
Query Joins 2
SQL query to Access database 5
Query with several tables. 5
Update TableA with data from TableB using Update Query 3
Is there a join that does this? 2
select Statement w/i inner joins 4
Encapsulated queries and parameters 4

Top