script where <> but i need to add = to it?

[qliklizzy]

hi this sounds really simple but is drivin me mad..

i have this script where  i have a <> applied and  i need to add:

Where Theatre = 'R1' and R2 and R3 also?

Where  Specialty <> 'A&E'  and SessionCancellationReason <> 'ROLLING HALF DAY' and SessionCancellationReason <> 'RHD' 

thanks

[rubenmarin]

Hi Elizabeth, I suposse Theatre will have only one value and you want those with any of those values: R1, R2 or R3, if this is the case you can use

Where  Specialty <> 'A&E'  and SessionCancellationReason <> 'ROLLING HALF DAY' and SessionCancellationReason <> 'RHD' 

  and (Theatre='R1' or Theatre='R2' or Theatre='R3')

[#3 · Accepted solution]

Hi Elizabeth,

try adding

Where  Specialty <> 'A&E'  and SessionCancellationReason <> 'ROLLING HALF DAY' and SessionCancellationReason <> 'RHD'

and Match(Theatre, 'R1','R2','R3')

hope that helps

Joe

[qliklizzy]

thank you- easy when you know how!!!