Solved

delete query in access

Posted on 2014-12-04
2
164 Views
Last Modified: 2014-12-04
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
0
Comment
Question by:PeterBaileyUk
2 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,

pls try to use

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

Regards
0
 

Author Closing Comment

by:PeterBaileyUk
Comment Utility
perfect thank you was struggling with that one
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now