Excluding data from a multi-table query

[Guest]

I have a task as follows:

- User provides a SSN in a form
- Value is passed to a query that looks up multi-records in Table1 based on
that SSN
- One of the columns in Table1 is TeamID
- Lookup all records in Table2 whose TeamIDs are NOT in Table1 for that SSN

So if I have the following values in Table2 for TeamID: 1,2,3,4,5

and the following values in Table1 for TeamID (multiple records mind you): 3,5

My final result will be data from Table2 for TeamIDs 1,2,4

For some reason, I am unable to make this happen. Any ideas? I'd sure
appreciate it!

Thanks!

 

[Roger Carlson]

Check out the Find Unmatched Query Wizard in the New Query tab.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks. I want to code this in VBA. Can that example be of assistance?

 

[Guest]

Please ignore my preceding reply. This does what I need. Thanks!

 

[Guest]

Well, it *almost* does what I need to do. I need to look at the exclusion
table by SSN. So IF for SSN 111-22-3333, there is a TeamID of "3" on file, I
do NOT want to show TeamID 3 in the drop-down (since it's already assigned to
that SSN).