[AccessD] Query trouble

[Ryan W]

You want AND between your criteria, not OR I believe. 

Sent from my iPhone

> On Oct 8, 2019, at 3:24 PM, Kaup, Chester <Chester_Kaup at kindermorgan.com> wrote:
> 
> I am trying to use both a not like and not equal statement in the same query. Either criteria work correctly by itself. When I use both nothing is excluded. What might I be doing wrong? Below is the SQL statement. Thanks.
> 
> SELECT dbo_DSS_LastStatus.PID, dbo_DSS_LastStatus.Completion_Name, dbo_DSS_LastStatus.Status, [tbl Petra Current Status Copy].[Sym Code] INTO [tbl Petra and DSS Status]
> FROM (dbo_DSS_LastStatus INNER JOIN dbo_DSS_CompletionMaster ON dbo_DSS_LastStatus.PID = dbo_DSS_CompletionMaster.PID) INNER JOIN [tbl Petra Current Status Copy] ON dbo_DSS_CompletionMaster.ParentPID = [tbl Petra Current Status Copy].[UWI (APINum)]
> GROUP BY dbo_DSS_LastStatus.PID, dbo_DSS_LastStatus.Completion_Name, dbo_DSS_LastStatus.Status, [tbl Petra Current Status Copy].[Sym Code]
> HAVING ((([tbl Petra Current Status Copy].[Sym Code]) Not Like "PA*")) OR ((([tbl Petra Current Status Copy].[Sym Code])<>"P&A"));
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com