| | |
|
|
|
Seemingly Simple Sample management |
|---|
| message from =?Utf-8?B?Q0gzM0NI?= on 11 May 2004 |
Hello-
I have a main Table of 50,000+ magazine subscribers. Every so often I am given a list of 2000 or so contacts (name, company, addy, etc etc etc...) and asked to determine which and how many entries from the smaller table also exist in the main subscriber table, so the salespeople can attack those who are not subscribers.
I already assume certain inherent caveats, like how many unique "John Smiths" we have, but it is well worth the small margin of error than having to go through the lists manually.
I answered all of management's OTHER questions using the advanced filters in Excel, but I am stumped by this seemingly simple task.
I assume this can be done with an Access query, but posted in General Questions just in case someone has another idea.
Thanks yet again everyone, much appreciated.
|
| Brendan Reynolds replied to =?Utf-8?B?Q0gzM0NI?= on 11 May 2004 |
SELECT NewTable.Name, NewTable.Company, NewTable.Address
FROM NewTable LEFT JOIN OldTable ON (NewTable.Address = OldTable.Address)
AND (NewTable.Company = OldTable.Company) AND (NewTable.Name =
OldTable.Name)
WHERE (((OldTable.Name) Is Null) AND ((OldTable.Company) Is Null) AND
((OldTable.Address) Is Null));
There's a "Find Unmatched Query Wizard" that can do this for you when the
two tables can be joined on a single field, but it doesn't seem to be able
to cope with multiple field joins.
|
| =?Utf-8?B?Q0gzM0NI?= replied to Brendan Reynolds on 11 May 2004 |
SELECT DISTINCTROW [TFM Att Full].Name, [TFM Att Full].Company
FROM [TFM Att Full] LEFT JOIN [TFM CIRC FILE 050604] ON [TFM Att Full].Name = [TFM CIRC FILE 050604].NAME
WHERE ((([TFM CIRC FILE 050604].NAME) Is Null));
|
|
Archived message: Seemingly Simple Sample management (Microsoft Access)
