Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Update table

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
gogetsome
Asked:
gogetsome
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
UPDATE [DMR Tracking]
SET [DMR Tracking].SCRAP = True
WHERE IsNull([DMR Tracking].SCRAP) AND IsNull([DMR Tracking].RTV)
0
 
gogetsomeAuthor Commented:
Thank you! I see said the blind man.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now