Load Criteria help required

[samvile18]

Afternoon all,

I need to reduce some records being returned from an access table, I'm going to do it based on the following criteria...I just can't get the syntaz quite right:

UNITCD = 'STAKEHOLD'

UNITCD = 'NGS'

QUEUECD <> 'END'

STATCD <> 'COMPLETED'

How do I ensure that these are all being met in the where clause?

[alexandros17 · Accepted solution]

(UNITCD = 'STAKEHOLD' or UNITCD = 'NGS')

And

QUEUECD <> 'END'

And

STATCD <> 'COMPLETED'

[samvile18]

Lovely job, thanks very much.