Which ARE NOT Duplicates!?!?

[Isaac Sanchez]

I have two tables Materlist(ML) and Weeklylist(WL).
ML has all the people I am responsible to deliver to
and WL has all the people I will be delivering to that week.
How can I do a query that will tell me the names that
are NOT in table ML that are in table WL.
Basically the query will tell me who the NEW people
are in my route.

TIA

Isaac

 

[Guest]

SELECT WL.*
FROM WL LEFT JOIN ML ON WL.names = ML.names
WHERE ML.names Is Null;

You need to put in the proper field names for the three "names" above.

 

[Granny Spitz via AccessMonster.com]

Basically the query will tell me who the NEW people
are in my route.

SELECT WL.FirstName, WL.LastName
FROM Weeklylist AS WL LEFT JOIN Masterlist AS ML ON WL.FirstName = ML.
FirstName AND WL.LastName = ML.LastName
WHERE ISNULL(ML.FirstName) AND ISNULL(ML.LastName);

 

[Isaac Sanchez]

Okay, I put this in a query, yes?!?!
what will tell me which names are not duplicates?
the query is specific for this right?
I am missing something on this one can you
explain a little more, PLEASE?!?!

 

[Guest]

Have you triend the "Find Unmatched Query Wizard" it will walk you through
the process.

 

[Granny Spitz via AccessMonster.com]

Okay, I put this in a query, yes?!?!

Yes, use SQL view.

what will tell me which names are not duplicates?

All rows will show *new people* on your route, names that occur on the weekly
list but not on the master list.

I am missing something on this one can you
explain a little more, PLEASE?!?!

You gave us the names of your two tables, Weeklylist and Masterlist, but you
didn't give us the names of the columns, so I gave you an example that shows
columns for each person's first name (FirstName) and last name (LastName).
If your columns are named differently you'll have to replace them with your
names in the query before you run it.

 

[Isaac Sanchez]

Okay to that working but now another Issue!!
I set a criteria on one of the fields, and it works
but what is odd is that I have to answer the question
FOUR times before it will show me the query results.

Here is the SQL behind the query:
SELECT DeliverT.CONSULTANT, DeliverT.[SHIP ADDR], DeliverT.[SHIP CITY],
DeliverT.[SHIP STATE], DeliverT.[SHIP ZIP], DeliverT.[PHONE NO]
FROM DeliverT LEFT JOIN [MASTER LIST 10-11-06] ON DeliverT.CONSULTANT =
[MASTER LIST 10-11-06].[Customer Name]
WHERE ((([MASTER LIST 10-11-06].[Customer Name]) Is Null) AND
((DeliverT.WEEK)=[Week?]));

Isaac