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.
Who is Participating?
Rgonzo1971Connect With a Mentor Commented:

pls try to use

WHERE (((TblModelLookup.ColourMatch)=False) AND ((DMin("[ColourMatch]","TblModelLookup"))=-1));

PeterBaileyUkAuthor Commented:
perfect thank you was struggling with that one
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.

All Courses

From novice to tech pro — start learning today.