Query that picks up records NOT the same

S

Sue Compelling

Hi

Using ACCESS 2007

I have two queries:

"Regions with Coordinators"
[Region] [Name] [ContactStatus] [ContactType]

And

"Regions with Volunteers"
[Region] [ContactStatus] [ContactType]


I now want to create a query that provides me with those Regions that are
represented in the first query but NOT in the second query ... (ie
Coordiantors that have no Volunteers assigned). Have tried many variations
though am only getting a dynaset of those that are featured in both.

TIA
 
L

Lord Kelvan

SELECT *
FROM [regions with coordinators]
where region not in (
select region
from [regions with volunteers])


something like that should do it

hope this helps

Regards
Kelvan
 
Top