Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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')
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
thank you- easy when you know how!!!