Removing unwanted records

  • Thread starter Thread starter Tammie
  • Start date Start date
T

Tammie

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query criteria - exclude data and return all records if null 3
Excluding Records when field has multiple values 2
Criteria & <> 4
All-Record criteria in a query...hmmm 4
count of records that meet criteria from two fields 1
OUTER JOIN HELP 4
How to exclude certain records 7
Query Criteria 1

Back
Top