By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

running a query to find missing names between 2 tables

P: n/a
I am quite new to access and having diffulty.
I have created 2 tables with all the same fields, ex. forename, surname,
email address.
on one table1 I have all the names I need to e-mail, with all there info..
on the other table2 I have copied from a shared worksheet, where the user
enters there forename, surname, email address.
How can I run a query to see if there is any names missing from table1,from
my table2.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
In the queries window of the main database window click the New button.
Don't click the New Query using Wizard in the window itself, you won't get
the correct wizard. Once you click the New button, choose the Find Unmatched
Query Wizard option, click Ok, and follow the directions.

--
Wayne Morgan
MS Access MVP
"lc via AccessMonster.com" <fo***@AccessMonster.com> wrote in message
news:a9******************************@AccessMonste r.com...
I am quite new to access and having diffulty.
I have created 2 tables with all the same fields, ex. forename, surname,
email address.
on one table1 I have all the names I need to e-mail, with all there info..
on the other table2 I have copied from a shared worksheet, where the user
enters there forename, surname, email address.
How can I run a query to see if there is any names missing from
table1,from
my table2.

--
Message posted via http://www.accessmonster.com

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.