easy fix for >< issue

[travismp]

SampleID2: IIf(Left([SampleID],1)<=4,"RED","BLUE")

This is original code which works great. Well my client made a change. Now the number "3" should be BLUE as well so my <=4 red no longer works.

What is the best way to set this up so numbers 1,2,4 are RED and 3,5,6,7,8,9are BLUE?

Thanks.

 

[Jon K]

SampleID2: IIf(Left([SampleID],1) In (1,2,4),"RED","BLUE")
.

 

[travismp]

thank you Jon K I will try it at lunch when I can get to the system.