How to create a delete query where a record contains certain crite

K

Kbass

I have imported about 10K and need to clean out records that contain certain
values such as everything that contains "xyz" and have it delete just those
records. I don't have a lot of knowledge with Access, but know there is a
way to create a query and tell it that if a record contains certain letters
to delete it. If anyone can help me out I would appreciate it.

Thanks,

Keith
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Delete query doesn't delete records 7
Working on birthday "book" for my wife and having layout/editing trouble 0
How to delete non-matching records by comparing with a table 3
Deleting many forms or queries or reports 10
Printing a Range Of Records Using A Button 1
When try to delete record, required field can't be null 3

Top