Avatar of davetough
davetough

asked on 

DELETING ONE FIELD WHERE ANOTHER FIELD HAS CERTAIN DESCRIPTION

hELLO,
I have a table and it has no primary key.
I want to delete records in one field where another field ="Out of Order"
It seems to be deleting the Out of Order records tooor all of record-
Can you just deltete data in one field (IdNo) and leave the rest of record intact?
thank you
DELETE [TABLE1].IdNo
FROM [REPAIR TABLE]
WHERE ((([TABLE1].Results)="Out of Order"));

Open in new window

SQL

Avatar of undefined
Last Comment
Sean Stuber
Avatar of Sean Stuber
Sean Stuber

update [REPAIR TABLE]
set IdNo = null
where Results = "Out of Order"
Avatar of davetough
davetough

ASKER

getting error about word null
I notice I did not give my right code
DELETE [TABLE1].IdNo
FROM [TABLE1]
WHERE ((([TABLE1].Results)="Out of Order"));
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SQL
SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

61K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo