pulling matching names from 2 queries

J

JP

I have two queries grouped by record:Name, and containing the field "Funder
ID". I need to pull all the names that contain a certain Funder ID "2", but
for each of those names, I need to pull all records regardless of which
Funder ID it is. Any idea on how I should do so?
 
J

Jeff Boyce

We aren't there. We can't see how your data (or tables) are structured.

"How" to do this will depend on how you have it organized.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

JP

Sorry I am very much a novice at this...

Each record in the query is categogorized by name, and there may be several
records with the same name. E.g, there are 6 records for Jenny Smith, and 4
records for Bob Jones. One field in the query is "Funder ID", and there are
six different types of Funder ID's. I am looking to pull every name that has
in one of its records, the funder ID "6". So if Jenny Smith has at least 1
record with the funder ID "6", I need the query to show all all of Jenny's
records. If Bob does not have any records with the funder ID "6", then none
of Bob's records should be shown.

Sorry, can't find a better way to ask this...
 
M

Michel Walsh

SELECT *
FROM tableNameHere
WHERE [Name] IN ( SELECT [Name]
FROM tableNameHere
WHERE funderID = 6)


Hoping it may help,
Vanderghast, Access MVP
 
Top