Exclude Query

[Tamika via AccessMonster.com]

I have a main table. From this main table I have created a query (qryexclude)
with a list of names and name id's that I don't want from the main table.
How do I create A new query to search the main table but not include names
that match my qryexclude?

Thanks,
Tamika

 

[[MVP] S.Clark]

So, you want to not exclude those name that are not currently excluded,
right?

I prefer to do this by solving by the inverse.

Add all names to a temp table. Then use a delete query to remove any
records that match the qryExclude results.

This will leave only those names that are Not excluded.

 

[Tamika via AccessMonster.com]

thank you. works great!!

So, you want to not exclude those name that are not currently excluded,
right?

I prefer to do this by solving by the inverse.

Add all names to a temp table. Then use a delete query to remove any
records that match the qryExclude results.

This will leave only those names that are Not excluded.

I have a main table. From this main table I have created a query
(qryexclude)

[quoted text clipped - 4 lines]

Thanks,
Tamika