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.