Removing unwanted records

Hello everyone. I am using an OBDC relational database,
so the tables are already pre-built. I need to create a
query(ies) for mailing(s) were certain people meeting
certain criteria are excluded. I've tried a Delete Query
but it won't work. I've tried Not in, not equal, none of
it works. Does anyboby have any suggestions?

How about a SELECT Query with proper criteria?

Check Access Help on SELECT Query. If you can't work it out, please post
details of your source (ODBC) Table and your selection criteria in words.

BTW, the person responsible for the source (ODBC) database may not be happy
with your attempts to delete the Records.

Are you aware that when you delete Records from the (ODBC-) linked Tables
(and if it is possible to delete), you actually delete the Records from the
ODBC source?

--
HTH
Van T. Dinh
MVP (Access)




"Tammie" wrote in message
...
Hello everyone. I am using an OBDC relational database,
so the tables are already pre-built. I need to create a
query(ies) for mailing(s) were certain people meeting
certain criteria are excluded. I've tried a Delete Query
but it won't work. I've tried Not in, not equal, none of
it works. Does anyboby have any suggestions?