Filtering on two criteria in table search

[Johnny]

Hi . I have a query that delivers fields from my table. But I need to filter
on two words in one field. The SQL for 1 expression looks as follows:
SELECT TABLE.ID, TABLE.E, TABLE.G, TABLE.Q, TABLE.V, TABLE.X
FROM

WHERE (((TABLE.E)="1") AND ((TABLE.G)="Type") AND ((TABLE.Q) Like "*Job
Close*") AND ((TABLE.V)="Dispatch") AND ((TABLE.X)<>"Telephone"));

This works fine. When I add a Or to my Table.X field I get the following
SELECT TABLE.ID, TABLE.E, TABLE.G, TABLE.Q, TABLE.V, TABLE.X
FROM

WHERE (((TABLE.E)="1") AND ((TABLE.G)="Type") AND ((TABLE.Q) Like "*Job
Close*") AND ((TABLE.V)="Dispatch") AND ((TABLE.X)<>"Telephone" Or
(TABLE.X)="Customer"));

This now returns records containing both the words I am trying to filter out
in my Query (Telephone & Customer). Any idea where I am going wrong?

 

[JaRa]

What do you expect as result of this query?

Should it only give Customers or should it give all records which are not
Telephone

- Raoul

 

[Johnny]

JaRa. I entered the last part incorrectly when typing in the SQL in my
question. it should be <> Telephone OR <> Customer. I want to return all
records that do not contain those words.

What do you expect as result of this query?

Should it only give Customers or should it give all records which are not
Telephone

- Raoul

Hi . I have a query that delivers fields from my table. But I need to filter
on two words in one field. The SQL for 1 expression looks as follows:
SELECT TABLE.ID, TABLE.E, TABLE.G, TABLE.Q, TABLE.V, TABLE.X
FROM

WHERE (((TABLE.E)="1") AND ((TABLE.G)="Type") AND ((TABLE.Q) Like "*Job
Close*") AND ((TABLE.V)="Dispatch") AND ((TABLE.X)<>"Telephone"));

This works fine. When I add a Or to my Table.X field I get the following
SELECT TABLE.ID, TABLE.E, TABLE.G, TABLE.Q, TABLE.V, TABLE.X
FROM

WHERE (((TABLE.E)="1") AND ((TABLE.G)="Type") AND ((TABLE.Q) Like "*Job
Close*") AND ((TABLE.V)="Dispatch") AND ((TABLE.X)<>"Telephone" Or
(TABLE.X)="Customer"));

This now returns records containing both the words I am trying to filter out
in my Query (Telephone & Customer). Any idea where I am going wrong?

 

[JaRa]

then the OR should be AND because you want all the conditions

- Raoul

JaRa. I entered the last part incorrectly when typing in the SQL in my
question. it should be <> Telephone OR <> Customer. I want to return all
records that do not contain those words.

What do you expect as result of this query?

Should it only give Customers or should it give all records which are not
Telephone

- Raoul

Hi . I have a query that delivers fields from my table. But I need to filter
on two words in one field. The SQL for 1 expression looks as follows:
SELECT TABLE.ID, TABLE.E, TABLE.G, TABLE.Q, TABLE.V, TABLE.X
FROM

WHERE (((TABLE.E)="1") AND ((TABLE.G)="Type") AND ((TABLE.Q) Like "*Job
Close*") AND ((TABLE.V)="Dispatch") AND ((TABLE.X)<>"Telephone"));

This works fine. When I add a Or to my Table.X field I get the following
SELECT TABLE.ID, TABLE.E, TABLE.G, TABLE.Q, TABLE.V, TABLE.X
FROM

WHERE (((TABLE.E)="1") AND ((TABLE.G)="Type") AND ((TABLE.Q) Like "*Job
Close*") AND ((TABLE.V)="Dispatch") AND ((TABLE.X)<>"Telephone" Or
(TABLE.X)="Customer"));

This now returns records containing both the words I am trying to filter out
in my Query (Telephone & Customer). Any idea where I am going wrong?