SQL statement with double negative

[aaslezak]

I need to write the Where clause on an SQL statement so they both have to be true and records are not included otherwise I want the records included. Here is the statement:


SELECT [AMA IT Count Developer Estimate Table].[Project #], Personnel.[Project ID], Personnel.[Person ID], Personnel.Name, Personnel.Title, Personnel.Assigned, Personnel.Complete, Personnel.[Actual Hours], Personnel.[Estimated Hours], Personnel.[MO Issues], Personnel.[Prod Issues], Personnel.[Remaining Hours], [AMA IT Count Developer Estimate Table].CountOfTitle INTO [AMA IT Personnel 1]
FROM [AMA IT Count Developer Estimate Table] INNER JOIN Personnel ON [AMA IT Count Developer Estimate Table].[Project ID] = Personnel.[Project ID]
WHERE ((Personnel.Title) Not Like "Estimate*" AND ([AMA IT Count Developer Estimate Table].CountOfTitle)<2);

So if either of these are false like the Personnel.Title is Estimate and the CountOfTitle is 1 then I want it included. If the Personnel.Title is not Estimate and the CountOfTitle is 2 I want it included in the query. So how do I write the statement.

[JoeM]

Your logic is a bit confusing and seems to possibly contradict itself in certain places. I cannot be certain what you actually want.

Can you restate your question this way:
I want to include the record if:
Condition 1 is met
AND/OR
Condition 2 is met.

So, what I am looking for is what Condition 1 is, what Condition 2 is, and is it an AND or an OR thing.
Nothing else. Let's keep it that simple.

[aaslezak]

It's okay I figured it out I just needed an or statement.

SELECT [AMA IT Count Developer Estimate Table].[Project #], Personnel.[Project ID], Personnel.[Person ID], Personnel.Name, Personnel.Title, Personnel.Assigned, Personnel.Complete, Personnel.[Actual Hours], Personnel.[Estimated Hours], Personnel.[MO Issues], Personnel.[Prod Issues], Personnel.[Remaining Hours], [AMA IT Count Developer Estimate Table].CountOfTitle INTO [AMA IT Personnel 1]
FROM Personnel LEFT JOIN [AMA IT Count Developer Estimate Table] ON Personnel.[Project ID] = [AMA IT Count Developer Estimate Table].[Project ID]
WHERE (((Personnel.Title) Not Like "Estimate*") AND (([AMA IT Count Developer Estimate Table].CountOfTitle)>0)) OR (((Personnel.Title) Like "Estimate*") AND (([AMA IT Count Developer Estimate Table].CountOfTitle)=1));