Brad Marks
BradM at blackforestltd.com
Thu Sep 16 15:34:13 CDT 2010
Is it possible to specify a range of values in a Switch Function that is used in an Access query? I have a Switch Function like this sample - DerivedGroup: Switch([Product] In ("1","2","3","4","5"),"Product Group One",True,"Default Product Group")) I would like to specify a range rather than spelling out each possible value Something like =("1" through "5") Thanks for your help, Brad