Difficult Query...

M

Mark

I have 2 queries that I would like to query against a database to have the
data that does NOT match become my final results. Does this make sense?

Let me break it down a little better:

1. I have a list of contacts that I need to import into our marketing
database program (GoldMine)
2.Some of those contacts are already in there, and assigned to a sales
person.
3. I exported those sales person's lists and queried them against my list
(#1) so I knew which contacts I should NOT import into GoldMine.
4. So, back to my question. I need to get the end results and export them
out of Access and they should not include and contacts that are already in
GoldMine.

Sorry, but it's been a long day and I cannot seem to word this any better...

ANY help would be appreciated!

Thanks!
 
M

[MVP] S.Clark

Anytime that you want to see what's NOT there, requires an Outer Join.
Right Click on the line between the tables, and choose Join Properties.
Change it to 2 or 3, depending on which table needs it. Then, use the Is
Null criteria on the opposite ID.
 
J

John Vinson

1. I have a list of contacts that I need to import into our marketing
database program (GoldMine)
2.Some of those contacts are already in there, and assigned to a sales
person.
3. I exported those sales person's lists and queried them against my list
(#1) so I knew which contacts I should NOT import into GoldMine.
4. So, back to my question. I need to get the end results and export them
out of Access and they should not include and contacts that are already in
GoldMine.
Click to expand...

Use the "Unmatched Query Wizard" to create a query which will exclude
the #1 list from your contacts. Base your export on that query.

If the wizard doesn't help post back - it's not hard to do this
manually. It would help if you provided a bit of the structure of your
contacts table and the "exclude" list table.

John W. Vinson[MVP]
 
Top