Using OR in a query

[Mike Hughes]

I’m looking for records where the
SOURCE_BATCH=I and DT_DISTRIBUTE between 10/01/2010 and 10/31/2010
Or
SOURCE_BATCH=I and DT_DISTRIBUTE is null and STATUS_RECEIPT IS = H

The query below seems to be ignoring what is in the OR section of the query.

I’ve tried changing the DT_DISTRIBUTE to 12/31/9999

Can someone tell me what I’m doing wrong?



SELECT
NOLDBA_RECEIPT.ID_PAYOR,
NOLDBA_RECEIPT.DT_BATCH,
NOLDBA_RECEIPT.CD_SOURCE_BATCH,
NOLDBA_RECEIPT.NO_BATCH,
NOLDBA_RECEIPT.SEQ_RECEIPT,
NOLDBA_RECEIPT.AMT_RECEIPT,
NOLDBA_RECEIPT.DT_DISTRIBUTE

FROM NOLDBA_RECEIPT

WHERE NOLDBA_RECEIPT.CD_SOURCE_BATCH="I" AND
NOLDBA_RECEIPT.DT_DISTRIBUTE Between #10/1/2010# And #10/31/2010#

OR

NOLDBA_RECEIPT.CD_SOURCE_BATCH="I" AND
NOLDBA_RECEIPT.DT_DISTRIBUTE Is Null AND
NOLDBA_RECEIPT.CD_STATUS_RECEIPT="H";

 

[boblarson]

You need to use parentheses to separate the two possible criteria groups:

WHERE (NOLDBA_RECEIPT.CD_SOURCE_BATCH="I" AND
NOLDBA_RECEIPT.DT_DISTRIBUTE Between #10/1/2010# And #10/31/2010#)

OR

(NOLDBA_RECEIPT.CD_SOURCE_BATCH="I" AND
NOLDBA_RECEIPT.DT_DISTRIBUTE Is Null AND
NOLDBA_RECEIPT.CD_STATUS_RECEIPT="H");