Solved

Update table

Posted on 2013-10-28
2
220 Views
Last Modified: 2013-10-28
Hello,

I'm learning Access SQL and need to select all records where Scrap and RTV are null so I can find those records.

Then I need to perform an update statement to set the Scrap = true if both are null


My first is the select statement so I can see where both are null.

SELECT [DMR Tracking].SCRAP, [DMR Tracking].RTV
FROM [DMR Tracking]
Where ([DMR Tracking].SCRAP and  [DMR Tracking].RTV) = false

Which does not work.

How would I do the select and the update statements for this scenario.

I know this is real simple. I'm still in the learning syntax.
0
Comment
Question by:gogetsome
2 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39606505
UPDATE [DMR Tracking]
SET [DMR Tracking].SCRAP = True
WHERE IsNull([DMR Tracking].SCRAP) AND IsNull([DMR Tracking].RTV)
0
 

Author Closing Comment

by:gogetsome
ID: 39606569
Thank you! I see said the blind man.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
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.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question