Mixing my NOT's and OR's in my Access query ??

[dsundy2003]

Hi there

I want to write a query that says "Give me the records where transaction date > #7 July 2002# and where the Status <> "PUR" or where Status <> "SET" "

I have tried all combinations, watching my brackets etc. But its not giving me what I want. Is it becasue I am mixing my NOT's and OR's is a single statement, which is confusing the logic ? But surely putting brackets will solve that problem.

Darryn

 

[dk]

Hi there

I want to write a query that says "Give me the records where transaction date > #7 July 2002# and where the Status <> "PUR" or where Status <> "SET" "

I have tried all combinations, watching my brackets etc. But its not giving me what I want. Is it becasue I am mixing my NOT's and OR's is a single statement, which is confusing the logic ? But surely putting brackets will solve that problem.

Darryn

Hi,

I think you need an AND, not an OR. Can you post the SQL of your query?

I did this to return all records where the date is >7th July 2002 and where the Status isn't PUR and it isn't SET.

SELECT *
FROM MyTable
WHERE (((MyTable.TransactionDate)>#7/7/2002#) AND ((MyTable.Status)<>"PUR") AND ((MyTable.Status)<>"SET"))

 

[Aladin Akyurek]

Hi there

I want to write a query that says "Give me the records where transaction date > #7 July 2002# and where the Status <> "PUR" or where Status <> "SET" "

I have tried all combinations, watching my brackets etc. But its not giving me what I want. Is it becasue I am mixing my NOT's and OR's is a single statement, which is confusing the logic ? But surely putting brackets will solve that problem.

Darryn

In Visual Query Language (Query Grid), try...

Where TransactionDate > 7-Jul-02

and

Where Status NOT IN ("PUR","SET")