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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER