Avatar of PeterBaileyUk
PeterBaileyUk

asked on 

delete query in access

I have a table where I have marked a yes/no with true. for each Vin field group i want to delete the false records but not sure how to construct the query.

one thing if the vin field has all false then leave as is

see attached, this says in the example given that the vin has colour match to blue so therefore it cannot be any of the others.
ee.JPG
Microsoft AccessSQL

Avatar of undefined
Last Comment
PeterBaileyUk

8/22/2022 - Mon