Query that picks up records NOT the same

[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

 

[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

 

[Sue Compelling]

Ah my liege - you are a legend.

Your humble servant .....

 

[Lord Kelvan]

you always amuse me ^_^

your welcome