Hint: Their teams ended up taking quizzes, too.
Course Of The Month
7 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Access SQL Query to Delete records based on Condition
Posted on 2015-02-24
I have a table that needs to be dedicated to just one customer. However, the records do not have the customer names listed like I would like. I need to delete some records based on a condition that is one of the fields.
Table Name: DSCNSKPIUPDATE
Field Name: Reject
Condition: R0*
So In my field "Reject" I have several different formats of text. However, I only want to keep the records that start with "R0".
** The records have back up copies for the other customers **
The text look like these...
R0117730
R0116926
R0118216
or
N/A
20140903436
2014070323
1
To be released
As you can see there are many different formats. I need to remove all records that do not start with "R0".
Table Name: DSCNSKPIUPDATE
Field Name: Reject
Condition: R0*
So In my field "Reject" I have several different formats of text. However, I only want to keep the records that start with "R0".
** The records have back up copies for the other customers **
The text look like these...
R0117730
R0116926
R0118216
or
N/A
20140903436
2014070323
1
To be released
As you can see there are many different formats. I need to remove all records that do not start with "R0".
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
5 Comments
You can use this query..
I'm assuming you are using this in access:-
Change the RO one in single quotes if you are working in SQL and remove * from the same...
Saurabh...
I'm assuming you are using this in access:-
Delete * from DSCNSKPIUPDATE
where left(Reject,2)<>"RO"
Change the RO one in single quotes if you are working in SQL and remove * from the same...
Saurabh...
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Suggested Courses
Course of the Month7 days, 9 hours left to enroll
728 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.