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.
gogetsomeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim HornConnect With a Mentor Microsoft 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
All Courses

From novice to tech pro — start learning today.