Query that picks up records NOT the same

  • Thread starter Thread starter Sue Compelling
  • Start date Start date
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
 
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
 
Back
Top