[AccessD] Range of Values in Access Switch Function

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




More information about the AccessD mailing list