Where clause not working (Resident Load)

[#1]

Hello,

I have the below script;

QUALIFY *;

Chart3:

LOAD

AuditPhase,

AuditPhaseID,

[Region Only],

NumYearMonth,

[DDQ Submit]

Resident TABLE1

Where NumYearMonth = 27 and

[AuditPhase]='DDQ' or [AuditPhase]='OSI' or [AuditPhase]='EDD';

The NumYearMonth = 27 filter is not working, and after I run the script I still have all values in the new Chart3 table.

NumYearMonth is a created field using the autonumber() function.

[swuehl · Accepted solution]

What are you trying to achieve with your where clause? Are you maybe looking for

..

Where NumYearMonth = 27 and

( [AuditPhase]='DDQ' or [AuditPhase]='OSI' or [AuditPhase]='EDD' );

Please note the additional bracketing.

[#3]

Thank you swuehl, that DID IT!!!

I have opened a new question title "Help with Where clause" is related to the same case, I would appreciate if you can have a look.

Thank you!!!